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

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

65 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
outdelivering18689(None) 
delivering1545173___delivering
outdeliver1452183outdeliver___
outdelivered176943outdeliver_ed
outdelivers1551763outdeliver__s
redelivering1752413_redelivering
outdesigning1551534outdesi_gning
outdriving1545584outd_riv__ing
outglittering1551034out_glittering
outliving1337794out__liv__ing
deliveries1446015___deliveries
desilvering1663305___desilvering
livering122012385_____livering
nondeliveries1762315nondeliveries
outachieving2151155outachi_eving
outcapering1643335out__capering
outclimbing1872245out_cli_mbing
outdaring1179725outd____aring
outdebating1543295outde__bating
outdrinking1743965outd_ri_nking
outdriven1344325outd_rive__n_
outdueling1244595outd___ueling
outduelling1342975outduel___ling
outfeeling1445075outfe___eling
outfiguring1682245out__figuring
outfiring1338165out__fi__ring
outgiving1436215out__giv__ing
outglaring1246275out_gl__aring
outhearing1438445outhe___aring
outhomering1743905out__homering
outkeeping1744265outke___eping
outlining10310505out__li__ning
outliver11268785out__liver___
outlivers12246155out__liver__s
outloving1336715out__lov__ing
outmaneuvering2012675outmaneuvering
outmastering1552965out_mastering
outnumbering1751165out_numbering
outpowering1743175out__powering
outrivaling1543755out__rivaling
outsavoring1542965out__savoring
outseeing1038335outse___e_ing
outselling1188025outsel___ling
outserving1446745outse_rv__ing
outsleeping1443295out_sl_eeping
outslicking1843735out_sli_cking
outsteering1244555out__steering
outstriving1543795outstriv__ing
outtelling11107135outtel___ling
outthieving1842455out_thi_eving
outtowering1542855out__towering
outtraveling1652035out_traveling
outwearing1437185outwe___aring
outweeping1644465outwe___eping
outweighing1942745outwe_i_ghing
outyelling14116145outyel___ling
outyelping16123975outyel___ping
postdelivery2161195postdeliver__y
quivering2235875qu____ivering
redeliveries1652225_redeliveries
slivering1338085____slivering
telfering1336255__t_el_fering
telphering1644205__t_elphering
unbelieving1752265_unbeli_eving
undelivered1652645_undeliver_ed

Search took 10 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 Filter1786911247900.406440125.6
2DLD Change Limit124790659.26613467.5
3Display Results65650.0461413.0
 (SQL Overall)178691659.71818387.6
 
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.