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 “ordo” 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.

117 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
ordo5462235(None) 
fordo97218651fordo
ordos65216201ordos
orzo134516781orzo
ado49146872_ado
arco68331542arco
ardor64617862ardor
arvo76023432arvo
brio65432492brio
bro56236602br_o
broo65129822broo
condo85322592condo
cord76740922cord_
cordon95017292cordon
cords86030622cords
credo84815562credo
dado67126332dado
dido66528192dido
do310155252__do
dodo66024912dodo
dorado838812dorado
eddo63411802eddo
ergo56420152ergo
fado87226462fado
fido87726392fido
ford86835492ford_
fords95328182fords
foredo10510822foredo
forgo94418332forgo
fro65530642fr_o
horde94623052horde
judo125315302judo
kudo96115102kudo
lido56028152lido
lord55032082lord_
lords64923502lords
mondo85721232mondo
morro73216952morro
od39255242o_d_
oda48133042o_da
odd57725452o_dd
odds68919922odds
ode47446582o_de
odor55718092o_dor
ods47546212o_ds
oho66534382o_ho
old47033462old_
olds55926572olds
oldy85316842oldy
oleo46630482oleo
olio46829672olio
ono36838032o_no
onto46127662onto
or27354732or__
ora37250832or_a
orad56031692orad
oral47638122oral
orb55736862or_b
orbs66626252orbs
orby97519602orby
orc57034922or_c
orca65522772orca
orcs67025432orcs
order65019362order
ore36661832or_e
ores46056682ores
orgy85218002orgy
orle45630462orle
orlon5415002orlon
orlop7410902orlop
orra46120722orra
ors35750112or_s
ort39465232or_t
ortho8312292ortho
orts46538332orts
oryx14510212oryx
orzos143311252orzos
otto45220642otto
oud47439072oud_
ouds56430102ouds
outdo6312702outdo
ouzo133516932ouzo
overdo10128362overdo
oxo107322962o_xo
porno75120652porno
prao66229022prao
pro55837262pr_o
prod76129502prod
redo56029362redo
rho65924832_rho
rod47953892rod_
rode55844302rode
rodeo65921092rodeo
rods56442062rods
rondo65218372rondo
rood56733002rood
roto45935052roto
soldo67116562soldo
sord56237202sord_
sordor7310212sordor
sords64527802sords
sorgo64719722sorgo
tardo65321102tardo
tondo69718682tondo
toro48045682tor_o
torso56922142torso
trio45233342trio
trod57627952trod
udo49027302_udo
undo55620152undo
updo76712882updo
urd46427042urd_
urds55922422urds
uredo65112992uredo
word89832002word_
words95425072words
wordy126916162wordy

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 Filter178691298720.0762351197.4
2DLD Change Limit298721171.04628558.3
3Display Results1171170.0167312.5
 (SQL Overall)1786911171.138157022.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.