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 “preboiled” 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
preboiled145578(None) 
reboiled11349391_reboiled
parboiled1445222parboiled
potboiled1443272potboiled
prebilled1445062prebilled
preboil1148952preboil__
preboils1267292preboil_s
prebooked1863912prebooked
prebuild1344302prebuil_d
precooled1446362precooled
prefiled143310572pre_filed
prevailed1536042prevailed
recoiled113613212_recoiled
reoiled84316852_re_oiled
boiled95020953___boiled
broiled103811423br__oiled
overboiled1646133overboiled
panbroiled1542013panbroiled
pebbled1445403p_eb_bled
penciled1337823p_enciled
peopled1238503p_e_opled
periled10316323p_e_riled
petioled1137993p_etioled
potboiler1352843potboiler
preambled1643893preambled
prebaked1737173preb_aked
prebid113512843preb_i__d
prebill1138803preb_il_l
prebills1237293preb_ills
prebind123810643preb_i_nd
preboard1338263prebo_ard
preboarded1663893preboarded
preboiling1546403preboiling
prebound1345893prebo_und
prebuilds1442633prebuilds
prebuilt1247033prebuil_t
prechilled1843893prechilled
precised133213413pre_cised
precited133013813pre_cited
precoded1438863preco_ded
preconized2467143preconized
precooked1844993precooked
predried12309573predri_ed
predrilled1443453predrilled
preedited1337633preedited
prefile123413183pre_file_
prefiles133113443pre_files
prefilled1535513prefilled
prefired144310753pre_fired
prefixed21357703pre_fixed
preformed17176203preformed
preguided1443923preguided
preloaded1335923preloaded
premised133013193pre_mised
premixed20338013pre_mixed
premold1247863premo_l_d
premolded1544683premolded
prenticed14118063prenticed
preowned1435213pre_owned
prepriced1676643prepriced
presided12410553pre_sided
presliced1435983presliced
presoaked1635653presoaked
presold1059603preso_l_d
presolved1545273presolved
presorted1239453presorted
pretold1049083preto_l_d
prettied1159253pretti_ed
preunited1246803preunited
prevailer1445153prevailer
prevised143611073pre_vised
prewired14358473pre_wired
preworked1954653preworked
profiled14338523pr_ofiled
prowled13309913pr__owled
rebaited11410543_rebaited
rebelled113110333_rebelled
rebilled11318053_rebilled
rebodied1237243_rebodied
reboil83814683_reboil__
reboils94111723_reboil_s
rebooked15226503_rebooked
rebooted11248463_rebooted
rebored105015883_rebo_red
rebottled1243433_rebottled
rebuild1036293_rebuil_d
rebuilded1342743_rebuilded
recoaled113111783_recoaled
recoiler103210493_recoiler
recoined113614423_recoined
refiled114318653_re_filed
rejoiced18296923_rejoiced
rejoined16318593_rejoined
remailed112411403_remailed
renailed92512803_renailed
repolled11359623_repolled
rerolled93010053_rerolled
resailed93613063_resailed
resiled84621983_re_siled
resoled84119283_reso_led
retailed94113963_retailed
retiled84420513_re_tiled
retooled938473_retooled
reviled114417923_re_viled
revoiced14317873_revoiced
roiled74320053_r__oiled
trebled1038483treb__led
unboiled112410373_unboiled
upboiled13194853_upboiled

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.470380193.6
2DLD Change Limit1486411096.48322927.8
3Display Results1091090.0462369.6
 (SQL Overall)1786911096.99925530.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.