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

85 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
kithe12591746(None) 
kite85338251kit_e
kith115826371kith_
kithed144613011kithed
kithes135016651kithes
kiths125814981kiths
kythe15509671kythe
lithe84922011lithe
tithe85319701tithe
withe115220231withe
bathe105822882bathe
bite66547012bit_e
blithe115810862blithe
cite65640352cit_e
cither114616682cither
dite55547562dit_e
dither104417682dither
either94517422either
fiche134616742fiche
gighe10139732gighe
gite55438622git_e
hither124417252hither
ither84617602_ither
kibbe135211982kibbe
kibe106523462ki_be
kike76524802ki_ke
kiltie103210962kiltie
kine85643442ki_ne
kirtle10309472kirtle
kishke1254272kishke
kit78559892kit__
kitchen16287682kitchen
kited105120102kited
kiter95523222kiter
kites95432552kites
kits86441782kit_s
kitted115114832kitted
kittel10368872kittel
kitten104611482kitten
kittle104012172kittle
kitty124614572kitty
kyte117017772kyt_e
kythed17407312kythed
kythes16499132kythes
lathe85626722lathe
lethe85717302lethe
lite47054552lit_e
lither94520952lither
litho86513782litho
litre55421462litre
miche126219242miche
mite66249422mit_e
mither114218562mither
mitre75522422mitre
niche105016792niche
nite45943592nit_e
nitre57519682nitre
pith95432702pith_
pithed124615612pithed
piths105817542piths
pithy135614462pithy
rathe85821922rathe
rite45849462rit_e
saithe94713912saithe
sidhe95315112sidhe
site47052422sit_e
sith75435162sith_
skite95120062skit_e
swithe124010682swithe
the67436052__the
tithed104115592tithed
tither94920282tither
tithes94720212tithes
title54721072title
titre54619392titre
tythe115210452tythe
vitae84217632vitae
wite75443282wit_e
with105730482with_
withed134416232withed
wither124321352wither
withes124620842withes
withy144813762withy
writhe125310702writhe
zither183813082zither

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 Filter178691538001.420125838.7
2DLD Change Limit53800857.7366954.5
3Display Results85850.0461847.8
 (SQL Overall)178691859.20219418.7
 
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.