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

150 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
censual93766(None) 
sensual738051sensual
casual81112862c_asual
censure92310602censure
census84310302censu_s
cental84420962cen_tal
central93114472central
consul82312302consu_l
mensal84615662mens_al
mensural1046232mensural
accentual1343673accentual
annual64710703_annual
benthal1247953benthal
benzal1739643ben_zal
caesural1055393caesural
canal75428043can__al
canful11610263canfu_l
cannula937433cannula
cansful1236833cansful
cantal84122033can_tal
canthal12410053canthal
canula8312963can_ula
casuals91410523c_asuals
causal81413203caus_al
cecal94619113ce__cal
cedula977643ce_dula
cense75121403cens__e
censed94016323cens_ed
censer84516583cens_er
censers94313903censers
censes83721803cens_es
censing104215263censing
censor84011293cens_or
censorial11117503censorial
censors93611843censors
censurable1445653censurable
censured11248913censured
censurer10228133censurer
censures102211623censures
censused11184973censused
censuses10187543censuses
centai84814783cen_tai
centals94317053cen_tals
centas85020703cen_tas
centaur935783centaur
centra84113883centra_
centrals102712033centrals
centu76119413centu__
centum104012363centu_m
centums11398783centums
centuple12164043centuple
centurial1147953centurial
century1237193century
ceramal1138843ceramal
cercal10314123ce_rcal
cereal8315833ce_real
cesta75419483ce_sta_
cestas85018543ce_stas
cesura838763ce_sura
cesurae937703ce_surae
cesuras958693ce_suras
chasmal14158213chasmal
cingula10327173cingula
clausal936273clausal
coastal9411043coastal
coequal1844933coequal
conceal113313013conceal
conchal144211583conchal
congeal104011683congeal
conical11316203conical
conjugal1843513conjugal
consensual1253973consensual
consol82614113cons_ol
construal1146793construal
consular1038813consular
consuls92412313consuls
consult92513633consult
consume11510133consume
cornual94210173cornual
costal85419513c_ostal
crenshaw1642433crenshaw
crestal9312133crestal
crissal937413crissal
crustal939023crustal
crystal1237433crystal
cuneal8611513cun_eal
cuspal1037883c_uspal
cynical1437873cynical
cynosural1452293cynosural
denial74720513den_ial
dental74319173den_tal
dentural948083dentural
ensnarl784913_ensnarl
ensoul638253_ensoul
ensue54013833_ensu_e
ensued73610483_ensued
ensues63313813_ensues
ensure63416003_ensure
equal1449823_e_qual
eventual1144883eventual
festal94213563fe_stal
general81010933general
genial74917613gen_ial
genital849793genital
genua64614153gen_ua_
instal6712193_instal
lensman937563lensman
lingual8379083lingual
manual8313463man_ual
medusal1035183medusal
menial84223033men_ial
meniscal1246203meniscal
mensa75318673mens_a_
mensae84114053mens_ae
mensas85115863mens_as
menstrual1144353menstrual
mental84521603men_tal
mescal104113493me_scal
mesial84818083me_sial
penal75228373pen__al
penial84120893pen_ial
pensil83013333pens_il
perusal939193perusal
recusal968673recusal
refusal1056893refusal
renal55929503ren__al
renewal1038703renewal
rental63922023ren_tal
reseal64819643re_seal
scenical1247133scenical
seismal937303seismal
sendal73314993sen_dal
sensa54117473sens_a_
sensually1245313sensually
sensum849353sensu_m
sexual1338413se_xual
textual1444603textual
tissual745193tissual
unequal1644483unequal
ungual738183_ungual
unseal63315473_unseal
unusual743943unusual
usual5310183__usual
venal85523213ven__al
venial94218283ven_ial
ventral103612173ventral
versal93013753vers_al
vestal94615573ve_stal
visual938803_visual
xenial133414903xen_ial

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271507.40618097.1
3Display Results1501500.0632381.0
 (SQL Overall)1786911507.89222642.0
 
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.