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

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

71 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
centu7611941(None) 
cent67451011cent_
cento76625171cento
cents74730331cents
centum104012361centum
bent67759912bent_
bento75922952bento
bents76033692bents
cant66362032cant_
canto74931012canto
cants77036942cants
cantus85117762cantus
canty105226802canty
celt65646712celt_
celts75325782celts
cenote83715842cenote
cense75121402cense
census84310302census
centai84814782centai
cental84420962cental
centas85020702centas
centaur935782centaur
center84421412center
centos85920462centos
centra84113882centra
centre84316642centre
centrum1168602centrum
centums11398782centums
century1237192century
cesta75419482cesta
cesti75217422cesti
cestus84412912cestus
cete64934782ce_te
conte76633202conte
conto76027172conto
cunt66243672cunt_
cunts76125122cunts
dent57158412dent_
dents65031802dents
gent56954392gent_
gents65729612gents
genu55929072gen_u
hent76656382hent_
hents87330742hents
kent86846972kent_
kente95821072kente
lent46360532lent_
lento57223392lento
menta74424422menta
mentum104511712mentum
menu65130232men_u
pent66559072pent_
rent46661242rent_
rente54733782rente
rents55935182rents
scent75831622scent_
scents85317022scents
sent46963012sent_
sente56432882sente
senti56226702senti
tendu67216002tendu
tent46159862tent_
tenth85421832tenth
tents56434212tents
tenty86121602tenty
vent76049052vent_
vents86125932vents
vertu85017612vertu
went76051872went_
yenta83917042yenta
yente86220042yente

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit53800711.64032804.9
3Display Results71710.0302366.7
 (SQL Overall)178691711.98390111.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.