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

141 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
nitchie124723(None) 
nitchies1339071nitchies
bitchier15307732bitchier
fitchee152710782fitchee
itchier12247672_itchier
litchi1137892litchi_
litchis1238372litchis
niche105016792ni_ch_e
niterie7313742niterie
pitchier15368272pitchier
witchier16307882witchier
aitch105216163aitch__
aitches123014363aitches
biochip1645323biochip
bitch125017763bitch__
bitched153212923bitched
bitchen14349733bitchen
bitches144117063bitches
bitchiest1636083bitchiest
bitchily1844533bitchily
bitching163610623bitching
bitchy16479203bitch_y
botchier15287143botchier
catchier15329863catchier
conchie143312683conchie
dickie133913113di_ckie
ditch115015093ditch__
ditched143711903ditched
ditcher134012003ditcher
ditches133215713ditches
ditching15349943ditching
fiche134616743fi_ch_e
fitch134816873fitch__
fitches153516193fitches
fitchet153113563fitchet
fitchew18276803fitchew
fitchy17437623fitch_y
glitchier1542793glitchier
hickie153812473hi_ckie
hitch134515473hitch__
hitched163312253hitched
hitcher153712003hitcher
hitches153616273hitches
hitchhike2051663hitchhike
hitching173310523hitching
hoochie1537803hoochie
ischia1136393_ischia
itch95619173_itch__
itched123812023_itched
itches114916213_itches
itchiest1336523_itchiest
itchily1574493_itchily
itching134011683_itching
itchy13449013_itch_y
kimchee1845603kimchee
kimchi1743803kimchi_
kimchis1843733kimchis
kitchen16287683kitchen
kithe125917453kit_h_e
lichee114017973li_chee
lichi104412953li_chi_
lichis115212593li_chis
lithe84922013lit_h_e
lithia939333lit_hia
lithic1139493lit_hic
macchie1647193macchie
miche126219243mi_ch_e
milchig1543653milchig
mischief1846423mischief
natch105018223natch__
niacin8310223niac_in
nice65534713ni_c__e
niched125514063ni_ched
niches114419143ni_ches
niching133612433ni_ching
nickle123814483ni_ckle
nicoise937923ni_coise
nictate9310223nictate
niece74814503niec__e
nightie1179653nightie
nihil8410283ni__hil
nite45943583nit___e
niteries8318383niteries
nitid61817833nit__id
nitrate72017013nitrate
nitre57519683nit__re
nitric82512063nit_ric
nitrid72812233nit_rid
nitride82811243nitride
nitril62511533nit_ril
nitrile73011373nitrile
nitrite72314463nitrite
nittier73512243nit_tier
nitwit938593nit_wit
nixie125114943ni__xie
notch105613323notch__
notched134210303notched
notcher123610933notcher
notches123513653notches
notching14288583notching
nuchae11218513n_uchae
nutcase975763nutcase
outchid1338723outchid
outchide1447213outchide
patchier15319663patchier
pitch125018413pitch__
pitched153512923pitched
pitcher143813713pitcher
pitches143617753pitches
pitchiest1646703pitchiest
pitchily1855013pitchily
pitching163411113pitching
pitchmen1744333pitchmen
pitchy16479673pitch_y
pithier123010293pit_hier
rotche114311983rotch_e
sickie123715743si_ckie
snatchier1455353snatchier
snitch11357943snitch__
snitched14166863snitched
snitcher13157373snitcher
snitches13148983snitches
snitching1535913snitching
stichic1446243stichic
techie11511723_techie
tetchier1336453tetchier
tithe85319703tit_h_e
tittie63213153tit_tie
twitchier1753233twitchier
vichies15310623vi_chies
witch134517563witch__
witched163012193witched
witches152715793witches
witchiest1736313witchiest
witching173410633witching
witchlike2143103witchlike
witchy17468593witch_y
withe115220233wit_h_e
withier132910493wit_hier
withies133913543wit_hies
within123611383wit_hin

Search took 7 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.390458182.1
2DLD Change Limit1340271416.15621771.8
3Display Results1411410.0463065.2
 (SQL Overall)1786911416.59227107.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.