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

111 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
upboiled1319485(None) 
unboiled112410371unboiled
upcoiled13215181upcoiled
boiled95020952__boiled
reboiled11349392reboiled
spoiled104811352sp_oiled
unbroiled1235802unbroiled
uncoiled112512682uncoiled
unfoiled12249722unfoiled
unoiled82415482u_noiled
unsoiled92412082unsoiled
upboil1096452upboil__
upboils1184702upboil_s
upbuild1243002upbuil_d
uppiled12216592up_piled
assoiled935023assoiled
bailed94726653__bailed
boiler84319273__boiler
bolled94722653__bolled
bowled125018143__bowled
broiled103811423_broiled
coiled95123943__coiled
doiled84817293__doiled
embroiled1444593embroiled
entoiled968283entoiled
foiled104618403__foiled
moiled94318863__moiled
oiled64429473___oiled
parboiled1445223parboiled
peopled1238503_peopled
periled10316323_periled
piled85232993_p__iled
poised94918473_p_oised
poled84934843_p_o_led
polled94022003_p_olled
pooled94619813_p_ooled
potboiled1443273potboiled
preboiled1455783preboiled
profiled14338523_profiled
prowled13309913_prowled
recoiled113613213recoiled
reoiled84316853_reoiled
roiled74320053__roiled
soiled73822473__soiled
speiled104412123sp_eiled
spiled94621993sp__iled
spoiler93310683sp_oiler
spooled104613523sp_ooled
subsoiled1245453subsoiled
toiled74420323__toiled
topsoiled1242643topsoiled
turmoiled1242603turmoiled
umbeled12208193umb_eled
umbelled1336273umbelled
unbaled103315963unb_aled
unbilled1188693unbilled
unbobbed1234413unbobbed
unbodied1237263unbodied
unbolted1179323unbolted
unbonded12299763unbonded
unboned103014223unbo_ned
unbooted1188773unbooted
unbottled1244153unbottled
unbowed132610243unbo_wed
unboxed17249573unbo_xed
unbridled1344973unbridled
unbuild1035723unbuil_d
uncoined111813023uncoined
uncooled112710633uncooled
unhailed12219963unhailed
unjoined16248443unjoined
unmailed11229763unmailed
unnailed9229443unnailed
unpeopled1444533unpeopled
unpiled102312743u_npiled
unpoised1139183unpoised
unpolled1168943unpolled
unrolled9610413unrolled
unspoiled12255563unspoiled
unveiled1298163unveiled
unvoiced14106303unvoiced
upbind11246313upb_i_nd
upboiling1444633upboiling
upbore10247883upbo_re_
upborne11255133upborne_
upbound12134813upbo_und
upbraided1542963upbraided
upbuilder1441573upbuilder
upbuilds1341753upbuilds
upbuilt1144043upbuil_t
upcoil10126193upcoil__
upcoils1184933upcoil_s
upcurled1393783upcurled
updived1434093up_dived
updried11226473updri_ed
upfield1343033up_field
upfold12124953upfo_l_d
upfolded1542883upfolded
uphold12126903upho_l_d
uploaded1234533uploaded
uppile10178503up_pile_
uppiles11208263up_piles
upraised11167413upraised
uprooted1186393uprooted
uproused1135833uproused
upscaled13144873upscaled
upsized19246253up_sized
upsoared11154353upsoared
uptilted1174683up_tilted
uptossed1142933uptossed
upwelled1434663upwelled

Search took 7 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.410435831.7
2DLD Change Limit1461621116.37322934.6
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.82926166.5
 
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.