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

84 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
censusing124481(None) 
censuring1237601censuring
censing104215262cen__sing
censoring1238782censoring
cessing103814812ce_s_sing
confusing1537332confusing
consuming1437912consuming
contusing1239142contusing
ensuing8239542_ensu_ing
ensuring9310172_ensuring
bemusing1336613be_musing
callusing1236173callusing
campusing1654913campusing
canvasing1546433canvasing
capsuling1444533capsuling
carousing1237893carousing
caucusing1443803caucusing
causing103614413c__ausing
ceasing104118263ce__asing
census84310303census___
censused11184973census_ed
censuses10187543census_es
centering122915143centering
centring112112953cen_tring
centupling1543013centupling
chorusing15246113chorusing
chousing14259423c_housing
classing113211793clas_sing
closuring1255173closuring
coenduring1444233coenduring
cohousing1535283cohousing
coinsuring1345373coinsuring
concussing1546143concussing
conducing1537693conducing
confuting1539093confuting
conjuring1937913conjuring
consisting1349523consisting
consoling12310873consoling
consulting1349083consulting
convulsing1645383convulsing
crossing112612693cros_sing
cussing103814273c_us_sing
defusing13227943de_fusing
delousing1136303delousing
denuding1137113den_uding
disusing1039013_disusing
effusing1534273_effusing
encasing11610823_encasing
enduing9249723_endu_ing
enduring10310013_enduring
ensiling9410723_ensiling
enskying1633283_enskying
ensouling1046003_ensouling
enthusing1355213_enthusing
enuring8813883_en_uring
excusing1836503_excusing
fessing113812863fe_s_sing
incusing1159953_incusing
infusing1237903_infusing
insuring9311153_insuring
jessing153710623je_s_sing
lensing84015103len__sing
measuring1236123measuring
mensing103915103men__sing
messing103916393me_s_sing
misusing1138893_misusing
nonusing939233non_using
perfusing1565633perfusing
perusing11811063pe_rusing
recusing112512883re_cusing
refusing122310873re_fusing
rehousing1337253rehousing
reinfusing1443613reinfusing
reinsuring1146383reinsuring
reissuing1034613reissuing
resuming11310083re_suming
reusing82516783re__using
sensating1039253sensating
sensing84116953sen__sing
tensing84616653ten__sing
tenuring938863ten_uring
tonsuring1046503tonsuring
venturing1337553venturing
yessing113210063ye_s_sing

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.436409841.7
2DLD Change Limit148641847.45319943.8
3Display Results84840.0302800.0
 (SQL Overall)178691847.91922564.8
 
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.