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

110 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
ceinture103631(None) 
ceintures1136731ceintures
censure92310602ce_nsure
centare93113702ce_ntare
centre84316642ce_nt_re
century1237192ce_ntury
cincture1245582c_incture
coinsure1046932coinsure
denture8311892de_nture
geniture946452geniture
jointure15134832jointure
reinjure1544982reinjure
reinsure837912reinsure
venture10311172ve_nture
calenture1144303calenture
capture1138913c_apture
censured11248913ce_nsured
censurer10228133ce_nsurer
censures102211623ce_nsures
centares102913893ce_ntares
centaur935783ce_ntaur_
centaurea1143503ce_ntaurea
centaurs1035733ce_ntaurs
centaury1343953ce_ntaury
center84421413ce_nter_
centered112513523ce_ntered
centers94420603ce_nters
centiare1067203ce_ntiare
centile94217183ce_ntile
centime114513033ce_ntime
centner946853ce_ntner
centra84113883ce_nt_ra
centred103411683ce_nt_red
centres93817123ce_nt_res
centrum1168603ce_ntrum
centu76119413ce_ntu__
centum104012363ce_ntu_m
centums11398783ce_ntums
centuple12164043ce_ntuple
centuries11311333ce_nturies
cinctured1444273c_inctured
cinctures1346063c_inctures
cinque1736853c_inqu_e
cloture9238453c_loture
coendure1145463coendure
coenure968153coen_ure
coiffure1643123coiffure
coinhere1337133coinhere
coinsured1245513coinsured
coinsurer1144773coinsurer
coinsures1136723coinsures
cointer93616723cointer_
cointers103616413cointers
conjure16109073c_onjure
contuse9311413c_ontuse
couture9310623c_outure
creature1038733creature
crenature1145753crenature
crittur9315133crittur_
critturs10374593critturs
cubature1244693cubature
culture939393c_ulture
debenture1243473debenture
denature938063denature
dentures9312453de_ntures
endure74014143_e_ndure
ensure63416003_e_nsure
entire61617703_e_ntire
enure53520223_e_n_ure
feature1039853fe_ature
fixture1734963_fixture
genitures1046123genitures
gesture839243ge_sture
injure133410863__injure
insure63416603__insure
inturn63411563__inturn
inure54119053__in_ure
jointured17133483jointured
jointures16124873jointures
lecture9149513le_cture
leisure736693lei_sure
mixture1635413_mixture
moisture1046653moisture
picture1158613_picture
reincur945133reincur_
reincurs1045553reincurs
reinduce1165423reinduce
reinfuse1144783reinfuse
reinjured1744533reinjured
reinjures1645053reinjures
reinjury1842603reinjury
reinsured1036983reinsured
reinsurer945603reinsurer
reinsures937963reinsures
reinter73116843reinter_
reinters82614773reinters
remixture1843673remixture
renature839323renature
scripture1343883scripture
seisure738193sei_sure
seizure1634683sei_zure
tenure6311613te_n_ure
texture1497083te_xture
tincture1044673_tincture
veinule1056243vein_ule
ventured1238273ve_ntured
venturer1137243ve_nturer
ventures11311493ve_ntures
venturi1037203ve_nturi
vesture10310373ve_sture

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621106.73621698.6
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.21824756.3
 
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.