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

121 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
oorie5302636(None) 
ourie54027291ourie
aerie54634602aerie
bogie89524102bogie
boobie104015292boobie
boogie93515992boogie
bookie123516002bookie
bootie85421152bootie
bore66051332bor_e
boric98024222boric
boride9415902boride
borne77926792borne
brie65837902_brie
cookie123716042cookie
coolie83821602coolie
cootie84223072cootie
corbie103618202corbie
core67263112cor_e
coria75828302coria
corrie83621212corrie
corse75036182corse
cosie74728262cosie
cowrie113814272cowrie
cozie163519122cozie
curie74533032curie
dobie84920332dobie
dogie75222792dogie
doobie94712682doobie
doolie73916832doolie
doozie163910642doozie
dore56353302dor_e
dories75232362dories
dormie9312622dormie
dowie94721142dowie
doxie136017152doxie
eerie55228532eerie
eyrie88117832eyrie
fogie96719002fogie
foodie104413842foodie
footie94718132footie
force105324272force
fore78351472for_e
forge95126942forge
forme105225992forme
forte86131462forte
goodie83613992goodie
goonie73615562goonie
gore55744962gor_e
gorge76423892gorge
gorier73719372gorier
gorse65926812gorse
homie104622522homie
hoodie105116132hoodie
hoolie93217772hoolie
horde94623052horde
horse86132652horse
kookie9389832kookie
kore85834162kor_e
kyrie123712902kyrie
looie55624242looie
loonie64216452loonie
lore45850352lor_e
lories64933042lories
loris55329152loris
louie55023512louie
moire71017322moire
monie75631652monie
moorier93113072moorier
morae75831192morae
more67154522mor_e
morse76032702morse
movie105319132movie
moxie144018122moxie
noogie73612312noogie
nookie103712432nookie
nori47133142nori_
noria55722182noria
noris54928272noris
norite63221132norite
odorize1737402odorize
ogre56320742ogr_e
oldie6415472oldie
oolite63319602oolite
ootid61416692ootid
ooze136420602oo_ze
oozier153610252oozier
ore36661832_or_e
oriel54920422_oriel
orle45630462_orle
oroide7311702oroide
orrice81410162orrice
orris54516552orris
poori74816232poori_
pooris83916842pooris
pore66451262por_e
roofie93411172roofie
rookie103613262rookie
roomie83013872roomie
sore47059532sor_e
sori46039832sori_
sortie63621982sortie
toonie63617992toonie
tore47359322tor_e
tori47542152tori_
toric76529312toric
tories65435882tories
torii55521592torii
torse55833332torse
torte55431702torte
towie85821872towie
vogie95116662vogie
woodie103513612woodie
woolie93514482woolie
wore77144672wor_e
worse86525262worse
yore76335942yor_e
yowie114616452yowie
zori137722922zori_
zoril143916692zoril
zoris145320012zoris
zowie174313842zowie

Search took 5 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.0931921408.6
2DLD Change Limit538001213.33016156.2
3Display Results1211210.0631920.6
 (SQL Overall)1786911213.48651259.6
 
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.