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

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

82 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
consensuses135313(None) 
consensus1144922consensu__s
censuses10187543c___ensuses
conceptuses1774513conceptuses
condensates1445313condensates
condenses12710133conden__ses
conenoses1188903con_en_oses
confesses1438623confe_s_ses
consciouses1554563consciouses
consensual1253983consensu_al
conspectuses1852373conspectuses
dissensuses1152413dissensuses
nonsenses948343nonsen__ses
nonsensuous1152463nonsensuous
boninesses121111454bonines_ses
canonesses1238424canones_ses
censures102211624c___ensures
censused11184974c___ensused
closenesses1347844closenesses
coarsenesses1447244coarsenesses
coassumes13103894coas__sumes
coendures1245214co__endures
coenures1048684co__en_ures
coinsures1136724co__insures
coldnesses1338424coldnes_ses
coleuses1039724co_le__uses
colossuses1243024co_lossuses
compensates1745724compensates
concisenesses1746594concisenesses
concusses1346344con_cus_ses
condensate1345544condensate_
condense1179614conden__se_
condensed1387114conden__sed
condenser1287414conden__ser
condensers1386374condens_ers
conenose1078594con_en_ose_
confessed1546054confe_s_sed
confuses13310364co___nfuses
congresses1348024congres_ses
conjectures22134894conjectures
consecrates1548394consecrates
consensually1753164consensually
consented12311944consen__ted
consenter11312494consen__ter
consenters12410844consen_ters
consents102715894consen___ts
conserves14311194conse__rves
consonances1545774consonances
constitutes1376164constitutes
construes11410134cons_tru_es
consuetudes1452774consuetudes
consumes12310414co___nsumes
contessas1145024conte_s_sas
contextures2054124contextures
continues11310994contin_u_es
contuses10413454co___ntuses
convenes132916914conven___es
conventuals1665174conventuals
converses14311164conve__rses
coolnesses1237194coolnes_ses
corninesses13410594cornines_ses
cornuses10310034co__rn_uses
cosinesses121012824co_sinesses
countersues1348534countersu_es
countesses1248844counte_s_ses
couscouses1443914cous_couses
coynesses1437574coyne_s_ses
cozinesses21179504cozines_ses
crossnesses1247124crossnes_ses
danseuses1044134danse__uses
densenesses1247364densenesses
donenesses11310564don_enesses
fondnesses1437704fondnes_ses
gonenesses11310254gon_enesses
lonenesses10311344lon_enesses
longnesses1138504longnes_ses
loosenesses1147244loosenesses
nonsense847394nonsen__se_
obsesses1036224_obse_s_ses
onenesses9311824_on_enesses
possesses1046324posse_s_ses
tensenesses1147614tensenesses

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 Filter1786911488190.406440125.6
2DLD Change Limit148819828.61017284.4
3Display Results82820.0461782.6
 (SQL Overall)178691829.06219718.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.