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

81 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
cite65640341cit_e
cited84421951cited
citer74827331citer
cites74435591cites
bite66547002bit_e
biter75030032biter
bites75641172bites
cate66254602cat_e
cater74840722cater
cates75951892cates
cee55952702c__ee
cete64934782cet_e
cetes75731102cetes
cider84723312cider
cimex16119132cimex
cine66242942ci_ne
cines75239682cines
cire65836372ci_re
cires74932912cires
cisted95217522cisted
citers85022982citers
cither114616682cither
citied94014142citied
cities84524852cities
citole8311502citole
city95122622cit_y
civet105828732civet
civie103716352civie
coatee84327222coatee
cooee74531022cooee
cote66648732cot_e
coted85033852coted
cotes76347842cotes
cute66440452cut_e
cuter74728232cuter
cutes79438322cutes
cutey105819792cutey
cutie76925932cutie
cuvee10316142cuvee
dite55547552dit_e
dites66339152dites
giftee103512082giftee
gite55438612git_e
gites65630182gites
hiree85427802hiree
item65620382_item
kite85338242kit_e
kited105120092kited
kiter95523212kiter
kites95432542kites
kithe125917452kithe
listee64223062listee
lite47054542lit_e
liter54736342liter
lithe84922012lithe
litre55421462litre
mite66249412mit_e
miter75734792miter
mites75141802mites
mitre75522422mitre
nite45943582nit_e
niter55028972niter
nites55736342nites
nitre57519682nitre
rite45849452rit_e
rites54442552rites
siree55238812siree
site47052412sit_e
sited65130742sited
sites56045432sites
tee38366872__tee
titer55430612titer
tithe85319702tithe
title54721072title
titre54619392titre
tutee5423522tutee
vitae84217632vitae
wite75443272wit_e
wited94727142wited
wites85536962wites
withe115220232withe

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.300595636.7
2DLD Change Limit53800811.51335558.5
3Display Results81810.0165062.5
 (SQL Overall)178691811.82997698.7
 
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.