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

101 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
unbroiled123580(None) 
unboiled112410371unb_oiled
broiled103811422__broiled
embroiled1444592embroiled
panbroiled1542012panbroiled
unbraided1336132unbraided
unbridled1344972unbridled
unbrowned1554052unbrowned
unbruised1244762unbruised
uncoiled112512682un_coiled
unfoiled12249722un_foiled
unoiled82415482un__oiled
unrolled9610412un_rolled
unsoiled92412082un_soiled
unspoiled12255562unspoiled
upboiled13194852upb_oiled
boiled95020953__b_oiled
brailed103914013__brailed
broiler92911753__broiler
embroiler1344093embroiler
engrailed1144323engrailed
enrolled967973en_rolled
entoiled968283en_toiled
parboiled1445223parboiled
reboiled11349393reb_oiled
roiled74320053___roiled
subsoiled1245453subsoiled
unaroused1046533unaroused
unbaled103315963unb__aled
unbilled1188693unb_illed
unblocked1864353unblocked
unblooded1343843unblooded
unbobbed1234413unb_obbed
unbodied1237263unb_odied
unbolted1179323unb_olted
unbonded12299763unb_onded
unboned103014223unb_o_ned
unbooted1188773unb_ooted
unbottled1244153unbottled
unbowed132610243unb_o_wed
unboxed17249573unb_o_xed
unbraced132310433unbr_aced
unbraid1037183unbrai__d
unbraked15289413unbr_aked
unbranded1336363unbranded
unbred92613303unbr___ed
unbridged1453923unbridged
unbridle1145393unbridle_
unbridles1244133unbridles
unbriefed1553523unbriefed
unbroke13217743unbro_ke_
unbroken14235073unbro_ken
unbrushed1544433unbrushed
unbuckled1843633unbuckled
unbuild1035723unb_uil_d
unbundled1344103unbundled
unburied11208513unburi_ed
uncoined111813023un_coined
uncooled112710633un_cooled
uncropped1644943uncropped
uncrossed1236323uncrossed
uncrowded1654143uncrowded
uncrowned1564753uncrowned
undefiled1446113undefiled
undrained1138523undrained
undried92314613undr_i_ed
undrilled1146663undrilled
unfrocked1944223unfrocked
ungroomed1343993ungroomed
ungrouped1343673ungrouped
unhailed12219963un_hailed
unironed939083uniro_ned
unjoined16248443un_joined
unmailed11229763un_mailed
unnailed9229443un_nailed
unpeopled1444533unpeopled
unpiled102312743un__piled
unpoised1139183un_poised
unpolled1168943un_polled
unpriced1338143unpr_iced
unprimed1337203unpr_imed
unprized2038513unpr_ized
unprobed1366973unpro_bed
unproved1457533unpro_ved
unraised91811883un_raised
unreeled91310333un_reeled
unrifled1237423un_rifled
unrimed102211633un_r_imed
unrobed102711213un_ro_bed
unroofed12106773un_roofed
unrooted9810513un_rooted
unroped102812113un_ro_ped
unruled8311373un_r_uled
unspooled12254913unspooled
untrained10510993untrained
untried82615853untr_i_ed
untroubled1342503untroubled
unveiled1298163un_veiled
unvoiced14106303un_voiced
upbraided1542963upbraided
upcoiled13215183u_pcoiled

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 Filter1786911486410.410435831.7
2DLD Change Limit1486411016.87321626.8
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.32924381.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.