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

108 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
unbolting123645(None) 
unbelting1237661unbelting
bolting104416762__bolting
unbaling11310682unbal_ing
unbottling1343132unbottling
unbowing1436992unbo_wing
unboxing1836112unbo_xing
uncoating12611922uncoating
unfolding1436062unfolding
unmolding1335822unmolding
unrolling1078562unrolling
unrooting1098832unrooting
aborting11710253_aborting
belting104119133__belting
boating103721303__boating
bolling103820883__bolling
booting103821363__booting
enfolding1444833enfolding
enrolling1087733enrolling
enrooting10128133enrooting
infolding1445413infolding
ingoting1039863ingo_ting
inholding1445113inholding
insolating1149153insolating
insulting1038053insulting
intorting10311423intorting
involuting1444613involuting
involving1644363involving
jolting153410913__jolting
knolling13206893kn_olling
knotting13236573kn_otting
knouting13226793kn_outing
molting103517173__molting
noting74120153_n_o_ting
rebooting12139033rebooting
revolting1339633revolting
snooling93013473snool_ing
snooting92813203sn_ooting
snorting92613373sn_orting
snouting92511923sn_outing
unabating1246753unabating
unbanning1235893unbanning
unbarring1236063unbarring
unbearing1239353unbearing
unbeing1039373unb__eing
unbending1337463unbending
unbinding1336513unbinding
unblocking1943693unblocking
unbolt83013893unbolt___
unbolted1179323unbolt_ed
unbolts9247803unbolt__s
unbonneting1462023unbonneting
unbosoming1552743unbosoming
unbracing1437023unbracing
unbraking1636933unbraking
unbudging1443793unbudging
unbuilding1443673unbuilding
unclosing1247753unclosing
unclothing1644143unclothing
uncloying1555813uncloying
uncoatings1384793uncoatings
uncocking1836233uncocking
uncoiling1238993uncoiling
uncorking1637403uncorking
uncrating12813183uncrating
undocking1735653undocking
undoing9312243undo__ing
undoubting14103333undoubting
undulating1247143undulating
unfitting1336423unfitting
ungloving1444713ungloving
ungluing1035863un_gluing
unhatting1335873unhatting
unhelming1535493unhelming
unhooding1435893unhooding
unhooking1735353unhooking
unhorsing1336853unhorsing
unhousing1335883unhousing
uniting8315823un__iting
unjointing1843963unjointing
unknotting1542663unknotting
unloading1137193unloading
unlocking1636073unlocking
unloosing1036113unloosing
unloving1277483unlo_ving
unmolten1044933unmolten_
unmooring1255813unmooring
unmoving1436253unmo_ving
unpiling1139753unpil_ing
unquoting1944763unquoting
unresting10311133unresting
unrobing1138063unro_bing
unroofing1385703unroofing
unseating10713203unseating
unselling10810333unselling
unsetting1088993unsetting
unsling8313643un_sl_ing
unstating10711213unstating
unvoicing1545083unvoicing
unweeting1336473unweeting
unwilling1337163unwilling
unwitting1335583unwitting
unyoking1636183unyo_king
upboiling1444633upboiling
upfolding1642943upfolding
upholding1643373upholding
uprooting1276903uprooting
uptilting1234713uptilting

Search took 9 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411088.00018580.1
3Display Results1081080.0462347.8
 (SQL Overall)1786911088.46921099.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.