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 “upcoiled” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

109 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
upcoiled1321518(None) 
uncoiled112512681uncoiled
upboiled13194851upboiled
coiled95123942__coiled
recoiled113613222recoiled
spoiled104811352sp_oiled
unboiled112410372unboiled
uncoined111813022uncoined
uncooled112710632uncooled
unfoiled12249722unfoiled
unoiled82415482u_noiled
unsoiled92412082unsoiled
upcoil10126192upcoil__
upcoils1184932upcoil_s
upcurled1393782upcurled
uppiled12216592up_piled
assoiled935023assoiled
boiled95020953__boiled
broiled103811423_broiled
ceiled94114953__ceiled
coaled95022713__coaled
coifed124113063__coifed
coiler84421593__coiler
coined94523603__coined
coled85540763__co_led
cooled95224593__cooled
cowled125218393__cowled
doiled84817293__doiled
entoiled968283entoiled
foiled104618403__foiled
moiled94318863__moiled
oiled64429473___oiled
peopled1238513_peopled
periled10316323_periled
piled85232993_p__iled
poised94918473_p_oised
poled84934843_p_o_led
polled94022003_p_olled
pooled94619813_p_ooled
profiled14338523_profiled
prowled13309913_prowled
reboiled11349393reboiled
recoaled113111793recoaled
recoiler103210493recoiler
recoined113614433recoined
reoiled84316853_reoiled
roiled74320053__roiled
scowled13398193_scowled
soiled73822473__soiled
speiled104412123sp_eiled
spiled94621993sp__iled
spoiler93310683sp_oiler
spooled104613523sp_ooled
subcooled1444403subcooled
subsoiled1245453subsoiled
supercoiled1655043supercoiled
toiled74420323__toiled
topsoiled1242643topsoiled
turmoiled1242603turmoiled
unbroiled1235803unbroiled
uncalled11810923uncalled
unchilled1545563unchilled
uncoated11314963uncoated
uncobbled1643663uncobbled
uncocked17248753uncocked
uncoded11312743unco_ded
uncoil8811853uncoil__
uncoils979533uncoil_s
uncombed1536323uncombed
uncooked15269113uncooked
uncorked152210403uncorked
uncoupled1445703uncoupled
uncurled1168963uncurled
unhailed12219963unhailed
unjoined16248443unjoined
unmailed11229763unmailed
unnailed9229443unnailed
unpeopled1444533unpeopled
unpiled102312743u_npiled
unpoised1139183unpoised
unpolled1168943unpolled
unrolled9610413unrolled
unspoiled12255563unspoiled
unveiled1298163unveiled
unvoiced14106303unvoiced
upboil1096453upboil__
upboils1184703upboil_s
upbuild1243003upbuil_d
upclimbed1841443upclimbed
upcoiling1444793upcoiling
upcurved16142993upcurved
updived1434093up_dived
updried11226473updri_ed
upfield1343033up_field
upfold12124953upfo_l_d
upfolded1542883upfolded
uphold12126903upho_l_d
uploaded1234533uploaded
uppile10178503up_pile_
uppiles11208263up_piles
upraised11167413upraised
uprooted1186393uprooted
uproused1135843uproused
upscaled13144873upscaled
upsized19246253up_sized
upsoared11154353upsoared
uptilted1174683up_tilted
uptossed1142933uptossed
upwelled1434663upwelled

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621097.34319904.9
3Display Results1091090.0333303.0
 (SQL Overall)1786911097.79622920.9
 
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.