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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
preboiling154640(None) 
reboiling12149821_reboiling
parboiling1545172parboiling
potboiling1544122potboiling
prebilling1595412prebilling
prebooking1944072prebooking
prebuilding1742382prebuilding
precooling1545962precooling
prefiling1549532pre_filing
prevailing1656722prevailing
recoiling121412412_recoiling
reoiling93217212_re_oiling
boiling103819673___boiling
broiling113112013br__oiling
overboiling1746843overboiling
panbroiling1652563panbroiling
pebbling1535073p_eb_bling
penciling1437413p_enciling
peopling1338353p_e_opling
periling11316863p_e_riling
prebaking1838063preb_aking
prebidding1783843prebidding
prebinding1696163prebinding
preboarding1744273preboarding
preboil1148953preboil___
preboiled1455783preboil_ed
preboils1267293preboil__s
prebuying1734303preb_uying
prechilling1943743prechilling
precising14413273pre_cising
precoding15109733preco_ding
preconizing2548233preconizing
precooking1945043precooking
predrilling1543673predrilling
preediting1447933preediting
prefiring1559073pre_firing
prefixing2246783pre_fixing
preforming1846233preforming
preguiding1544493preguiding
prehiring1548383pre_hiring
preloading1446583preloading
premising14412413pre_mising
premixing2157803pre_mixing
premolding1644673premolding
prenticing1547883prenticing
prepricing1746733prepricing
preselling1338693preselling
presiding13510903pre_siding
preslicing1546363preslicing
presoaking1736253presoaking
presolving1644363presolving
presorting1339983presorting
pretelling1338133pretelling
preuniting1347303preuniting
prevising15510873pre_vising
prewiring1547893pre_wiring
preworking2044233preworking
prewriting1647243prewriting
profiling1548233pr_ofiling
prowling1449993pr__owling
rebaiting12311643_rebaiting
rebelling122111163_rebelling
rebilling12228833_rebilling
rebodying1635003_rebodying
rebooking16146393_rebooking
rebooting12139023_rebooting
reboring11312783_rebo_ring
rebottling1343733_rebottling
rebuilding1443633_rebuilding
recoaling121312453_recoaling
recoining121313803_recoining
refiling123116533_re_filing
rejoicing19136943_rejoicing
rejoining17149223_rejoining
remailing122412473_remailing
renailing102813333_renailing
repolling122110203_repolling
rerolling102210373_rerolling
resailing103314253_resailing
resiling93520173_re_siling
resoling92916303_reso_ling
retailing103214733_retailing
retiling93319483_re_tiling
retooling1039093_retooling
reviling122917213_re_viling
revoicing15117713_revoicing
roiling83220453_r__oiling
trebling1139873treb__ling
upboiling1444633_upboiling

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 Filter1786911406030.423422437.4
2DLD Change Limit140603897.31319226.4
3Display Results89890.0461934.8
 (SQL Overall)178691897.78222962.1
 
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.