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

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

98 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
kirsches174384(None) 
kitsches1734071kitsches
birches143412322bir_ches
borsches1536002borsches
girshes11248292girs_hes
kirsch1532712kirsch__
airscapes1345023airscapes
airscrew13102933airscrew
airscrews1492323airscrews
airshed11258533airs_hed
airsheds12274963airs_heds
aitches123014363ai_tches
arches114822043_ar_ches
birched15349913bir_ched
birchen14347883bir_chen
birses84717733birs__es
bitches144117063bi_tches
borschts1542853borschts
braches144621223_braches
brioches15227253brioches
britches15278683britches
caroches15710693caroches
cinches144215773ci_nches
circles1139903cir_cles
ciscoes113610733ci_scoes
creches14313093_creches
curches143512743cur_ches
dishes104622653di_s_hes
ditches133215713di_tches
earaches13411313earaches
enriches1337263enriches
fiascoes13134923fiascoes
fiches145219533fi__ches
filches153410723fi_lches
finches153914193fi_nches
fishes125221343fi_s_hes
fitches153516193fi_tches
flysches1933123flysches
grinches1436953grinches
gurshes112210033gurs_hes
hirsles101510073hirs_les
hitches153616273hi_tches
inches114419673_i_nches
itches114916213_i_tches
kenches163912273k_enches
ketches164012193k_etches
kiboshes1744013kiboshes
kimchee1845603ki_mchee
kimchees1942943ki_mchees
kimchis1843733ki_mchis
kirtles11309663kir_tles
kishkes1334773ki_shkes
kisses104217333ki_s_ses
kitchen16287683ki_tchen
kitchens17195783ki_tchens
kithes135016653ki__thes
kitsch1533353kitsch__
kitschy1941983kitsch_y
klatches17157143klatches
klatsches1842233klatsches
knishes1438263knis_hes
krises105016083kris__es
kvetches2053583kvetches
larches124416453lar_ches
liches114724293li__ches
lurches123311663lur_ches
marches143921173mar_ches
marshes123615373mars_hes
mensches1536303mensches
merches144013763mer_ches
miches134320733mi__ches
miracles1238333miracles
miscues11312393mi_scues
niches114419143ni__ches
oraches124216473_oraches
parches143720003par_ches
perches143717953per_ches
pinches144117933pi_nches
pinscher1544813pinscher
pinschers1644383pinschers
piracies12312643piracies
pishes114722103pi_s_hes
pitches143617753pi_tches
porches143815673por_ches
putsches1535313putsches
qurshes19228573qurs_hes
riches115022083__riches
ruches114819583__ruches
smirches1535993smir_ches
soroches1338803soroches
torches123715443tor_ches
troches123715343_troches
tusches1237903_tusches
wiches144418753wi__ches
winches154714373wi_nches
wishes124920953wi_s_hes
witches152715793wi_tches
zilches21326303zi_lches

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.436409841.7
2DLD Change Limit146162987.65619091.2
3Display Results98980.0303266.7
 (SQL Overall)178691988.12222000.9
 
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.