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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
censused1118497(None) 
censured11248911censured
censuses10187541censuses
censed94016322cen__sed
censored11197952censored
censure92310602censure_
censurer10228132censurer
censures102211622censures
census84310302census__
cessed94615612ce_s_sed
confused1437032confused
consumed1337922consumed
contused1138442contused
ensued73610482_ensu_ed
ensured83512942_ensured
bemused1236713be_mused
callused1135853callused
campused1535253campused
canvased14246213canvased
capsuled1334533capsuled
caroused1149253caroused
caucused1344093caucused
caused95117043c__aused
ceased94920783ce__ased
cense75121403cen__se_
censer84516583cen__ser
censes83721803cen__ses
censual937663censu_al
censurers11256073censurers
censusing1244813censusing
centered112513523centered
centeses1079443centeses
centred103411683cen_tred
centupled14143163centupled
cereuses1049243cereuses
ceruse83914523ce_ruse_
ceruses93716233ce_ruses
cesses84221363ce_s_ses
cestuses1038083cestuses
chassed134712133chas_sed
chorused1446133chorused
choused135012463c_housed
classed104113653clas_sed
closured11266353closured
coendured1344083coendured
coinsured1245503coinsured
concussed1444753concussed
conduced14136953conduced
confuse1238853confuse_
confuses13310363confuses
confuted1437673confuted
conjured18117893conjured
consisted1238503consisted
consoled112911443consoled
consulted1277923consulted
consume11510133consume_
consumer1238503consumer
consumes12310413consumes
contuse9311413contuse_
contuses10413453contuses
convulsed1544383convulsed
crossed105313893cros_sed
cussed94917123c_us_sed
defused125211093de_fused
deloused1036973deloused
denuded10167663den_uded
disused93211023_disused
effused1434143_effused
encased103512313_encased
endued83910373_endu_ed
endured93611213_endured
ensiled82611433_ensiled
enskied1234653_enskied
enskyed1532503_enskyed
ensouled935833_ensouled
ensue54013833_ensu_e_
ensues63313813_ensu_es
ensure63416003_ensure_
ensurer73011903_ensurer
ensures73315903_ensures
enthused1245083_enthused
enured73315333_en_ured
excused1736293_excused
fessed104515063fe_s_sed
geniuses935933geniuses
genuses83510883gen_uses
incused102911173_incused
infused11329253_infused
insured83714253_insured
jessed144112303je_s_sed
leisured934763leisured
lensed74015473len__sed
measured1136463measured
mensed93916543men__sed
messed95018183me_s_sed
misused104111283_misused
perfused1445823perfused
perused103112183pe_rused
recused104714423re_cused
refused115114443re_fused
rehoused1239613rehoused
reinfused1344063reinfused
reinsured1036983reinsured
reissued944903reissued
resumed10310623re_sumed
reused75419563re__used
sensated938183sensated
sensed73918163sen__sed
tensed74817833ten__sed
tenured838363ten_ured
tonsured976383tonsured
uncensured1344003uncensured
unensured1044943unensured
unfused11319513_unfused
unused72012883_un_used
ventured1238273ventured
venuses103111413ven_uses
yessed104511163ye_s_sed

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621188.98616265.5
3Display Results1181180.0462565.2
 (SQL Overall)1786911189.20219418.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.