Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “ryots” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
ryots8531378(None) 
riots54922011riots
roots55933671roots
rots46454091r_ots
ryot75528561ryot_
argots74116032argots
blots75626172blots
boots75837972boots
bots66453952_bots
clots75627642clots
coots75636842coots
cots68054842_cots
crypts13397742crypts
cysts105912772cysts
dots55647662_dots
drylots1143742drylots
ergots74512372ergots
foots85528282foots
griots74713642griots
grots65025852grots
guyots1036002guyots
hoots84830252hoots
hots78349332_hots
jots116336142_jots
knots95614722knots
kyats125012442kyats
loots55431422loots
lots47652092_lots
moots75831662moots
mots66853162_mots
oots46446442_oots
phots105418502phots
plots75025672plots
pots66452362_pots
rafts87820632rafts
rants55935342rants
ratos55528762ratos
rats46260372r_ats
rayons94113342rayons
rents55935182rents
repots85621002repots
rests54935872rests
rets45352562r_ets
rhos76319062rho_s
rifts85718642rifts
riot45947212riot_
robots8313152robots
robs65837872r_obs
rocs65533662r_ocs
rods56442062r_ods
roes45954142r_oes
roms67038962r_oms
roods65125282roods
roofs85321152roofs
rooks95325042rooks
rooms75324682rooms
roost55730932roost
roosts64916322roosts
root45655922root_
rooty86423022rooty
rot37282952r_ot_
rota45834342r_ota
rotas54827722r_otas
rote46249022r_ote
rotes56143902r_otes
roti46332932r_oti
rotis56327062r_otis
rotl45029682r_otl
rotls55620162r_otls
roto45935052r_oto
rotos56027882r_otos
routs57133412routs
rows75941752r_ows
runts55927632runts
rusts55026992rusts
ruts44541492r_uts
ryas77224612ry_as
ryes75529352ry_es
rykes125513032rykes
rynds9569972rynds
scots74025912scots
shots84730852shots
slots54830532slots
snots55225122snots
soots55536212soots
sots45552452_sots
spots74424112spots
stots54828552stots
swots85518432swots
toots55331872toots
tots46654122_tots
trots56629942trots
tryouts1035312tryouts
trysts9448792trysts
wots76342892_wots
xysts15558122xysts
yobs96028082_yobs
yods86531182_yods
yoks116223742_yoks
yous76230652_yous
yows106433122_yows

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691538000.313570897.8
2DLD Change Limit538001011.45337026.8
3Display Results1011010.0303366.7
 (SQL Overall)1786911011.79699493.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.