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

67 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
debonairnesses177144(None) 
debonairness1561372debonairne_s_s
boninesses121111454__bon_i_nesses
bonninesses1337354__bonni_nesses
dearnesses1139584de___a_rnesses
desolatenesses1553974desolatenesses
secondarinesses1861564secondarinesses
bandinesses14109735__bandi_nesses
belongingnesses1961455belongingnesses
blearinesses1446545__blearinesses
bogginesses1555675__boggi_nesses
boozinesses22175805__boozi_nesses
boskinesses17136815__boski_nesses
bossinesses12117355__bossi_nesses
boxinesses19127905__bo_xi_nesses
colonialnesses1653055colonialnesses
daintinesses1346245d_ainti_nesses
deaconesses1445655de___aconesses
deadlinesses1446225de_adli_nesses
deadnesses1238945de___a_dnesses
deafnesses1436225de___a_fnesses
debonaire1242995debonair____e_
decompresses1972825deco_mpr_esses
decorousnesses1756565decorousnesses
defensivenesses2255785defensivenesses
definitenesses1864255definitenesses
demandingnesses2061745demandingnesses
dementednesses1853815dementednesses
demonesses1346705demo____nesses
densenesses1247365de__n_senesses
devotednesses1853275devo_tednesses
devoutnesses1683935devo__utnesses
dewinesses1438355de___wi_nesses
dinginesses1337475d__ingi_nesses
dodginesses1435435d__odgi_nesses
donenesses11310565d__on__enesses
donnishnesses1784115d__onnishnesses
dopinesses13159725d__o_pi_nesses
dorkinesses1647665d__orki_nesses
dottinesses1238135d__otti_nesses
dournesses1138245d__o__urnesses
dowdinesses1635725d__owdi_nesses
downinesses1536145d__owni_nesses
dozinesses20168635d__o_zi_nesses
drearinesses1347445d__rearinesses
drowsinesses1644385d_rowsi_nesses
entirenesses1249665_e__ntirenesses
exoticnesses2142685_exo_ticnesses
fairnesses1357385____fairnesses
hoarinesses14310225__ho_arinesses
leopardesses1571515le_opa_rdesses
looninesses1197995_loon_i_nesses
mercenarinesses1961775mercenarinesses
mooninesses13127945_moon_i_nesses
nearnesses1039105ne___a_rnesses
ordinarinesses1552355ordinarinesses
phoninesses1636455_phon_i_nesses
reconditenesses1863155reconditenesses
sponginesses1544775_spongi_nesses
stoninesses1138255_ston_i_nesses
tearinesses11311695te___arinesses
temporarinesses1961985temporarinesses
tendernesses1345075te__ndernesses
unfairnesses1543435__unfairnesses
venialnesses1555705ve__nialnesses
visionarinesses1861665visionarinesses
wearinesses14310215we___arinesses

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 Filter178691950240.1231452772.4
2DLD Change Limit95024677.36012910.9
3Display Results67670.0332030.3
 (SQL Overall)178691677.51623774.7
 
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.