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

302 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
britches1527868(None) 
bitches144117061b_itches
brioches15227251brioches
aitches123014362_aitches
batches144019612b_atches
bewitches1943822bewitches
birches143412322b_irches
bitched153212922b_itched
bitchen14349732b_itchen
blotches1537432blotches
botches143716022b_otches
braches144621222br_aches
branches153613802branches
breaches153714112breaches
breeches15258672breeches
brioche14275922brioche_
briths115113862brit_h_s
brittles10178652brittles
broaches153211622broaches
brooches15288192brooches
brunches153710452brunches
butches144315362b_utches
cratches153012542cratches
crotches153411292crotches
crutches15359582crutches
ditches133215712_ditches
fitches153516192_fitches
flitches16388462flitches
glitches14296652glitches
grinches1436942grinches
grutches14285852grutches
hitches153616272_hitches
itches114916212__itches
pitches143617752_pitches
quitches2236192quitches
ratches123620462_ratches
retches123318512_retches
riches115022082_ri_ches
rotches123515702_rotches
snitches13148982snitches
stitches131410592stitches
switches16159132switches
twitches16156372twitches
witches152715792_witches
wretches16257282wretches
writhes134811702writ_hes
arches114822043ar__ches
articles10310243articles
babiches1735253babiches
baches135426943b__aches
barites94322333barit__es
baritones1158943baritones
barouches1644973barouches
batched154114243b_atched
batcher144414853b_atcher
batchers153613273b_atchers
bathes116524833b_at_hes
beaches144120653b_eaches
beeches143413883b_eeches
belches143514343b_elches
benches143918603b_enches
berdaches1745053berdaches
bewitched2043233bewitched
bewitcher1943003bewitcher
bewitchers2042563bewitchers
bices95029963b_i_c_es
birched15349913b_irched
birchen14347883b_irchen
birthed13228593birt_hed
births115713603birt_h_s
bitch125017763b_itch__
bitchery18236563b_itchery
bitchier15307733b_itchier
bitchiest1636083b_itchiest
bitchy16479203b_itch_y
bites75641173b_it__es
blanches153311603blanches
bleaches153410673bleaches
blenches153310763blenches
blites84721213blit__es
blithe115810863blit_he_
blither124812173blit_her
blithers134711233blit_hers
blithest1338083blit_hest
blitzes18408703blit_zes
blotched1635653blotched
bobeches1744483bobeches
boches134618523b__oches
boites84322703boit__es
borsches1536003borsches
botched153611903b_otched
botcher143613223b_otcher
botchers153511543b_otchers
braces108427773br_ac_es
brachet144020313br_achet
brachets154311983br_achets
brachs134415753br_ach_s
branched163210453branched
brashes124518463br_ashes
brattles10199333brattles
breached163411643breached
breacher153011503breacher
breachers16369853breachers
breathes134212903breathes
breeched16337383breeched
bribees11409283bri_bees
bribes105918533bri__bes
bricked164312063bri_cked
brickles162810283brickles
bricks144614623bri_c_ks
bricoles122610303bricoles
brides94423513bri__des
bridges113911333bri_dges
bridles104114473bri_dles
bries74942153bri___es
brigades1236393brigades
brights133710233bri_ghts
brindles113710223brindles
brines85028853bri__nes
brinies93317913bri_nies
brionies10310543brionies
brises84927613bri__ses
brisses94314313bri_sses
bristles101510433bristles
brith104924373brit_h__
brits76433083brit___s
britskas14132713britskas
brittle9168603brittle_
brittled11186093brittled
brittler10165983brittler
brittlest11146193brittlest
britts84813443brit__ts
britzkas23132053britzkas
broached16309123broached
broacher15329263broacher
broachers16328133broachers
broche133612103br_oche_
bronchos15206173bronchos
bronchus15204743bronchus
brothel12318193brot_hel
brothels13277073brot_hels
brother123311333brot_her
brothers133410823brot_hers
broths115013923brot_h_s
brunched16317853brunched
bruncher15347783bruncher
brunchers16296253brunchers
brushes124014663br_ushes
brutes86118683brut__es
bunches144116033b_unches
butcher143411163b_utcher
butchers153710183b_utchers
bycatches2142683bycatches
carritches1743083carritches
catches144320763_catches
chinches18369363chinches
cinches144215773_cinches
cliches144213743cli_ches
clinches153910363clinches
clutches15307913clutches
cranches153114543cranches
creches14313093cr_eches
crotched16428593crotched
crotchet152711993crotchet
crotchets16396293crotchets
crouches153711283crouches
crunches153711353crunches
crutched16307463crutched
cultches15316533cultches
cutches143216453_cutches
ditched143711903_ditched
ditcher134012003_ditcher
ditchers143610363_ditchers
drenches14309803drenches
enriches1337263enri_ches
etches114217763__etches
fetches153413893_fetches
fetiches1636953fetiches
fiches145219533_fi_ches
filches153410723_filches
finches153914193_finches
fitchee152710783_fitchee
fitchet153113563_fitchet
fitchets16307413_fitchets
fitchew18276803_fitchew
fitchews19274773_fitchews
fletches16308853fletches
flinches16358953flinches
flitched17256293flitched
frenches163311633frenches
frites94922483frit__es
friths124313583frit_h_s
fritzes19329453frit_zes
griths105211653grit_h_s
grouches14328213grouches
grutched15284673grutched
hatches153420273_hatches
hitched163312253_hitched
hitcher153712003_hitcher
hitchers16379993_hitchers
hootches1656973hootches
hotches153814363_hotches
hutches153613523_hutches
inches114419673__inches
iritises839973iritises
itched123812023__itched
ketches164012193_ketches
kirsches1743843kirsches
kitchen16287683_kitchen
kitchens17195783_kitchens
kithes135016653_kit_hes
kitsches1734073_kitsches
klatches17157133klatches
kvetches2053583kvetches
latches123320123_latches
letches124015483_letches
liches114724293_li_ches
litchis1238373_litchis
matches143219783_matches
miches134320733_mi_ches
mutches143314283_mutches
nautches1336073nautches
niches114419143_ni_ches
nitchies1339073_nitchies
notches123513653_notches
oraches124216473or_aches
ornithes1136423ornit_hes
painches1588913painches
parritches1743223parritches
patches143320383_patches
pinches144117933_pinches
pitched153512923_pitched
pitcher143813713_pitcher
pitchers153211483_pitchers
potiches1539203potiches
preaches153214893preaches
prices104524543pri_c_es
princes113015143princ_es
prithee1239933prit_hee
quiches2139333qui_ches
ranches123620113_ranches
ratchet124218333_ratchet
ratchets133110263_ratchets
reaches123423203_reaches
retched133814273_retched
rices75536153_ri_c_es
richen113812513_ri_chen
richens12349733_ri_chens
richer114015043_ri_cher
richest122813683_ri_chest
rites54442553_rit__es
ritzes154812943_rit_zes
roaches123616213_roaches
rotche114311983_rotche_
rouches124217893_rouches
ruches114819583_r_uches
scotches15179473scotches
scratches1647313scratches
scutches15168883scutches
seiches12513813sei_ches
sketches1746823sketches
slatches131511523slatches
smirches1535993smirches
smutches15177273smutches
snatches131410713snatches
snitched14166863snitched
snitcher13157373snitcher
snitchers14166043snitchers
stitched14148203stitched
stitcher13168383stitcher
stitchers14146993stitchers
stretches1438283stretches
swatches16169963swatches
switched17157133switched
switcher16177683switcher
switchers17146633switchers
thatches1637513thatches
tithes94720213_tit_hes
tranches132915513tranches
trenches133512603trenches
trices84826333tri_c_es
tritones83413443tritones
troches123715343tr_oches
twitched17155033twitched
twitcher16135343twitcher
twitchers17134533twitchers
unhitches1743073unhitches
vetches153411263_vetches
watches153017373_watches
wiches144418753_wi_ches
winches154714373_winches
witched163012193_witched
withes124620843_wit_hes
wrenches163210233wrenches
wretched17276533wretched
writes94420333writ__es
writhe125310703writ_he_
writhed14389623writ_hed
writhen13407863writ_hen
writher134010853writ_her
writhers14398983writ_hers
zilches21326303_zilches

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.1561145455.1
2DLD Change Limit1461623028.61016975.8
3Display Results3023020.1232455.3
 (SQL Overall)1786913028.88920102.5
 
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.