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

115 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
thou7672221(None) 
tho67433961tho_
thous86017251thous
thru76818941thru
ahoy101919182ahoy
chon96627792chon
chop116024922chop
chow125820992chow
dhow116614002dhow
ethos85514192ethos
fou66743782_fou
ghoul959052ghoul
ho510258272_ho_
hob87550922_hob
hod76852462_hod
hoe67562722_hoe
hog78049062_hog
hon67759382_hon
hop87554592_hop
hos68364192_hos
hot67776052_hot
hour75827312_hour
how97252432_how
hoy97447912_hoy
khoum1476632khoum
meou65325862meou
mho86624622mho_
mhos95517772mhos
oho66534382oho_
phon95925382phon
phot95534352phot
rho65924832rho_
rhos76319062rhos
shod86225052shod
shoe75933432shoe
shog86025132shog
shoo75929882shoo
shop95629832shop
shot76150242shot
shout85433162shout
show106229182show
shoyu1138902shoyu
sou37853692_sou
tabu66328492tabu
tao38358952tao_
taos45541002taos
tau36856902t_au
thae76825562thae
than76128772than
that75639322that
thaw107521312thaw
the67436052th_e
thee78039062thee
them97427042them
then78429692then
thew108226232thew
they107223752they
thin76732382thin
thio77225412thio
thiol87616042thiol
thir76420542thir
this76027382this
thole85620842thole
thong95014172thong
thorn85318702thorn
thoro86217872thoro
thorp104414262thorp
those85218142those
thoued10429002thoued
though139410762though
thro77726422thro
throb109816852throb
throe89321422throe
throw118719732throw
thrum104713632thrum
thud85613912thud
thug86415482thug
thus76721472thus
thy97022912th_y
to218858982t_o_
tod49457072t_od
toe310166852t_oe
tofu76921332tofu
tog410255042t_og
tolu45529152tolu
tom514358052t_om
ton310265102t_on
too38965422t_oo
took86531072took
tool46735682tool
toom66532932toom
toon47740632toon
toot45958882toot
top510560682t_op
tor39261682t_or
tot38884772t_ot
tour45530372t_our
tout46753822t_out
tow610557362t_ow
toy69655192t_oy
trod57627952trod
trog57628212trog
trop66833302trop
trot46351312trot
trout57332572trout
trow78031422trow
troy77429682troy
tutu48423172tutu
two67925832two_
twos76718022twos
who95526772who_
whoa106615202whoa
whom127018172whom
whop125520922whop
you66641822_you

Search took 3 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 Limit298721151.81316476.6
3Display Results1151150.0462500.0
 (SQL Overall)1786911151.93592346.8
 
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.