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

110 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
things10491430(None) 
thing96622981thing_
thinks134613361thinks
thins85826331thin_s
thongs104611191thongs
tings65329211t_ings
agings86312672agings
ahing98928352ahing_
beings94613032beings
bhangs12449662bhangs
boings96416872boings
brings94618432brings
changs125215372changs
chinas115119402chinas
chines115029172chines
chinks155817572chinks
chinos115018692chinos
chins105631462chin_s
chints115117832chints
clings95716212clings
dings76331402_dings
doings84913182doings
dyings11478132dyings
etchings14396292etchings
flings106715282flings
goings84911522goings
hangs95726732_hangs
hinds96721482_hinds
hinge95323452_hinge
hinges105121032_hinges
hins76448002_hin_s
hints87330622_hints
hongs95126202_hongs
icings9428452icings
itchings14386192itchings
kings105825572_kings
lathings12469852lathings
lings67135772_lings
lyings10488502lyings
nothings12266682nothings
ohing96018812ohing_
pings85830882_pings
rhinos94411122rhinos
rings65029172_rings
shines95028912shines
shins85131042shin_s
sings65532702_sings
slings74618012slings
stings76220182stings
strings84617132strings
swings104714452swings
tahinis1048012tahinis
tains54936322tain_s
taints64520532taints
takings124512572takings
tangs65028362t_angs
teinds738262teinds
thanes94918982thanes
thanks134313132thanks
thegns10547432thegns
theines104013232theines
theins95015422thein_s
thens85921832then_s
thicks154511992thicks
thigh12410122thi_gh
thighs1346632thighs
thills95515382thills
thin76732392thin__
thine85026862thin_e
think125018802thin_k
thinly1238672thinly
thiols95112762thiols
thirds10438602thirds
thirls95012062thirls
this76027382thi__s
thong95014182thong_
throngs11508162throngs
thugs95611992th_ugs
thunks13459032thunks
tidings93810262tidings
tilings84212792tilings
timings10279302timings
tines54848422t_ines
ting56139922t_ing_
tinge64626632t_inge
tinges74722342t_inges
tins45251312t_in_s
tints56030922t_ints
tithings12327692tithings
tongs65928472t_ongs
trigs65423062tri_gs
trines64132562trines
tubings10336482tubings
tungs65520632t_ungs
twangs10358102twangs
twigs96911172twi_gs
twines94717272twines
twinge104210402twinge
twinges11409452twinges
twins85118982twin_s
tying96019842tying_
whangs13439722whangs
whigs125612642whi_gs
whines125120102whines
whinge134311542whinge
whinges143610632whinges
whins114922332whin_s
wings95727242_wings
wrings104012972wrings
zings154620892_zings

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 Filter178691825510.376475242.0
2DLD Change Limit825511104.43618609.3
3Display Results1101100.0303666.7
 (SQL Overall)1786911104.84236904.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.