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

183 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
thing9662298(None) 
ahing98928351ahing
ohing96018811ohing
thin76732391thin_
thine85026861thine
things104914301things
think125018801think
thins85826331thins
thong95014181thong
ting56139901t_ing
tying96019841tying
aahing1019015762aahing
aching126521972aching
acing87429152acing
aging77026352aging
aping87327232aping
ashing107824092ashing
awing96827322awing
axing138521372axing
bathing134816242bathing
being84920502being
bhang115512922bhang
boing84725552boing
bring85528502bring
chang115418562chang
chin96934742chin_
china105022482china
chine105231722chine
chink145321592chink
chino105823312chino
chins105631462chins
cling86424672cling
cuing85420192cuing
ding66940952_ding
doing74923582doing
dying105316032dying
eching126315562eching
eking106614982eking
etching134511842etching
exing136016812exing
eying96117922eying
fling97023512fling
going75218492going
hang85535552_hang
hin67559562_hin_
hind85529752_hind
hinge95323452_hinge
hins76447992_hins
hint77455742_hint
hong85833952_hong
hung86126352_hung
hying126514742hying
icing86017752icing
iring66025422iring
itching134011682itching
king95933662_king
kithing153411552kithing
kything18285522kything
lathing114315692lathing
ling57447962_ling
lying95717452lying
nothing113511902nothing
oohing104412932oohing
oping86322412oping
owing96222722owing
piing85218832piing
ping75943592_ping
pithing134014052pithing
rhino84614322rhino
ring56541152_ring
ruing67221052ruing
shin75634312shin_
shine85533092shine
shins85131042shins
shiny115122142shiny
shying134211842shying
sing57544172_sing
sling66028802sling
sting65330242sting
string75327562string
stying105414572stying
suing65026362suing
swing96124842swing
tahini939892tahini
tain45548072tain_
tains54936322tains
taint55542282taint
taking114725952taking
taming94023432taming
tang56138672t_ang
taping94222392taping
taring73932282taring
tawing104521552tawing
taxing143816712taxing
teeing73916972teeing
teind6213612teind
tewing103914822tewing
than76128772than_
thane86122532thane
thank125817802thank
thawing14378682thawing
thegn95810902thegn
thein85919022thein_
theine94814922theine
theins95015422theins
theming133610472theming
then78429692then_
thens85921832thens
thick145613352thick
thief114516302thief
thigh12410122thigh
thill85918732thill
thinks134613362thinks
thinly1238672thinly
thio77225412thi_o
thiol87616042thiol
thir76420542thi_r
third95912492third
thirl85416822thirl
this76027382thi_s
tholing112812332tholing
thongs104611192thongs
thouing11258602thouing
throng10539972throng
thug86415482th_ug
thunk124911852thunk
tiding83520092tiding
tieing73518762tieing
tiling73426552tiling
timing93619302timing
tin36362172t_in_
tine45855132t_ine
tinge64626622t_inge
tings65329202t_ings
tining74927542tining
tins45251302t_ins
tint46758862t_int
tiny76134632t_iny
tiring74023092tiring
tithing113513892tithing
toeing74418472toeing
toking114420722toking
toling73926122toling
tong56434352t_ong
toning74025792toning
toping94122992toping
toting74123792toting
towing103823192towing
toying105017302toying
trig55528162tri_g
trine54734602trine
truing73913932truing
trying104214072trying
tsking114210422tsking
tubing93813092tubing
tung55328162t_ung
tuning74016842tuning
tushing114214012tushing
twang94511852twang
twig87615772twi_g
twin76023082twin_
twine85822362twine
twinge104210402twinge
twins85118982twins
twiny116012812twiny
tyin76424002tyin_
tyning105510412tyning
typing124110582typing
tyring104613022tyring
tything14316572tything
using66317962using
vying125111812vying
whang124813382whang
whig115516422whi_g
whin105225692whin_
whine116022812whine
whinge134311542whinge
whins114922332whins
whiny144915572whiny
wing86339222_wing
withing143814492withing
wring95920712wring
zing145728612_zing

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 Limit538001831.45337026.8
3Display Results1831830.0632904.8
 (SQL Overall)1786911831.82997698.7
 
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.