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

166 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
kitchens1719578(None) 
kitchen16287681kitchen_
aitches123014362aitche_s
bitchen14349732bitchen_
bitches144117062bitche_s
ditchers143610362ditchers
ditches133215712ditche_s
fitches153516192fitche_s
fitchets16307412fitchets
fitchews19274772fitchews
hitchers16379992hitchers
hitches153616272hitche_s
itches114916212_itche_s
ketches164012192ketche_s
kimchees1942942kimchees
kitchenet1844982kitchenet
kitchenets1952322kitchenets
kithes135016652kit_he_s
kitsches1734072kitsche_s
kittens11347582kit_tens
kuchens1634712k_uchens
lichens123510682li_chens
pitchers153211482pitchers
pitches143617752pitche_s
richens12349732ri_chens
sithens1039382sit_hens
witches152715792witche_s
batchers153613273batchers
batches144019613batche_s
birchen14347883birchen_
birches143412323birche_s
bitched153212923bitche_d
bitchery18236563bitchery
bitching163610623bitching
bitumens1243523bitumens
botchers153511543botchers
botches143716023botche_s
britches15278683britche_s
butchers153710183butchers
butches144315363butche_s
catchers153114053catchers
catches144320763catche_s
cinches144215773cinche_s
citherns13338863cit_herns
cithers124315753cit_hers
cithrens13355933cithrens
citizens1943983citizens
cutches143216453cutche_s
dickens144410133di_ckens
ditched143711903ditche_d
ditcher134012003ditche_r
ditching15349943ditching
dithers114016153dit_hers
etchers123411293_etchers
etches114217763_etche_s
fetchers16328863fetchers
fetches153413893fetche_s
fiches145219533fi_che_s
filchers16286863filchers
filches153410723filche_s
finches153914193finche_s
fitchee152710783fitche_e
fitchet153113563fitche_t
fitchew18276803fitche_w
flitches16388463flitche_s
glitches14296653glitche_s
hatchels16368673hatchels
hatchers163113173hatchers
hatches153420273hatche_s
hatchets163310383hatchets
hitched163312253hitche_d
hitcher153712003hitche_r
hitching173310523hitching
hotches153814363hotche_s
hutches153613523hutche_s
inchers123912523_inchers
inches114419673_inche_s
itched123812023_itche_d
itching134011683_itching
itchings14386193_itchings
katchina1745333katchina
katchinas1843923katchinas
kenches163912273kenche_s
ketchups1941893ketchups
kickers124013293ki_ckers
kimchee1845603kimche_e
kimchis1843733kimch_is
kirsches1743843kirsche_s
kiters105218583kit__ers
kites95432543kit__e_s
kithe125917453kit_he__
kithed144613013kit_he_d
kithing153411553kit_hing
kiths125814973kit_h__s
kitten104611483kit_ten_
kitties113213623kittie_s
kittles113012493kittle_s
klatches17157133klatche_s
kuchen1536653k_uchen_
kvetchers2142373kvetchers
kvetches2053583kvetche_s
kythes16499133kyt_he_s
latches123320123latche_s
latchets133410013latchets
letches124015483letche_s
lichees123512783li_chees
lichen114012743li_chen_
liches114724293li_che_s
litchis1238373litch_is
matchers153012433matchers
matches143219783matche_s
miches134320733mi_che_s
mithers123516733mit_hers
mitogens1146973mitogens
mittens9349883mit_tens
mutches143314283mutche_s
niches114419143ni_che_s
nitchies1339073nitchies
notchers13279423notchers
notches123513653notche_s
patchers153413303patchers
patches143320383patche_s
pinchers153510613pinchers
pinches144117933pinche_s
pitched153512923pitche_d
pitcher143813713pitche_r
pitching163411113pitching
pitchmen1744333pitchmen_
quitches2236193quitche_s
ratches123620463ratche_s
ratchets133110263ratchets
retches123318513retche_s
richen113812513ri_chen_
riches115022083ri_che_s
rotches123515703rotche_s
satchels13328163satchels
sickens134411483si_ckens
sketchers1834513sketchers
sketches1746823sketche_s
snitchers14166043snitchers
snitches13148983snitche_s
stitchers14146993stitchers
stitches131410593stitche_s
switchers17146633switchers
switches16159133switche_s
thens85921833__t_hens
tithers104216733tit_hers
tithes94720213tit_he_s
twitchers17134533twitchers
twitches16156373twitche_s
vetches153411263vetche_s
watchers163511793watchers
watches153017373watche_s
wiches144418753wi_che_s
winchers16319223winchers
winches154714373winche_s
witched163012193witche_d
witchery19236093witchery
witching173410633witching
witchings18325303witchings
withers134417753wit_hers
withes124620843wit_he_s
withins133511693wit_hins
zilches21326303zilche_s
zitherns20376133zit_herns
zithers193911973zit_hers

Search took 9 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.1731032896.0
2DLD Change Limit1461621668.56317069.0
3Display Results1661660.0602766.7
 (SQL Overall)1786911668.79620315.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.