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

161 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
fletchers1733553(None) 
fetchers16328861f_etchers
fletcher16306661fletcher_
fletches16308851fletche_s
bleachers16297922bleachers
blenchers16356722blenchers
blethers13429612blet_hers
clenchers16276552clenchers
etchers123411292__etchers
fetcher153510392f_etcher_
fetches153413892f_etche_s
fleches153411442fle_che_s
fleecers13325932fleec_ers
fleeches16287082fleeche_s
flenches163410532flenche_s
fleshers14339442fle_shers
fletched17306692fletche_d
flinchers17295472flinchers
flitches16388462flitche_s
kvetchers2142372kvetchers
leachers133712812_leachers
lechers123313962_le_chers
letches124015482_letche_s
sketchers1834512sketchers
aethers103614943_aet_hers
batchers153613273_batchers
belchers153510023_belchers
benchers153611013_benchers
blanchers16307433blanchers
blathers134713793blat_hers
bleacher15358883bleacher_
bleaches153410673bleache_s
blencher15308393blencher_
blenches153310763blenche_s
blether12459913blet_her_
blithers134711233blit_hers
blotches1537433blotche_s
bluchers15359033bl_uchers
botchers153511543_botchers
breachers16369853breachers
butchers153710183_butchers
catchers153114053_catchers
clencher15277973clencher_
clenches152910953clenche_s
clinchers16336263clinchers
clutches15307913clutche_s
detachers1536483_detachers
diethers1257453diet_hers
ditchers143610363_ditchers
drenchers15296103drenchers
etcher113912943__etcher_
etches114217763__etche_s
ethers94518413__et_hers
fathers133916503f_at_hers
feathers143513243f_eathers
feldschers1941763feldschers
feldshers1643093feldshers
fencers123810623f_enc_ers
fetched163710473f_etche_d
fetiches1636953f_etiche_s
fetters103517903f_et_ters
filchers16286863f_ilchers
fitches153516193f_itche_s
fitchets16307413f_itchets
fitchews19274773f_itchews
flashers143912653fl_ashers
flatcars1344623flatc_ars
flatters113814203flat_ters
fleche14299303fle_che__
fleecer12368033fleec_er_
fleeces12399643fleec_e_s
fleeched17345823fleeche_d
fleecier1334763fleecier_
fleers96015793fle___ers
flenched17267963flenche_d
flensers1135463fle_nsers
flesher133610923fle_sher_
fleshes133913273fle_she_s
fletch14388193fletch___
fletching18256143fletching
fletchings19282863fletchings
flextimers2241373flextimers
flichters1774173fl_ichters
flickers17338883fl_ickers
flincher16256583flincher_
flinches16358953flinche_s
flitched17256293flitche_d
flitters114312173flit_ters
flushers14279733fl_ushers
fluters103713673flut__ers
flutters114010813flut_ters
flycatchers245943flycatchers
flysches1933123flysche_s
flytiers14254483flyt_iers
frenches163311633frenche_s
frescoers1454563frescoers
fretters113410303fret_ters
frothers14279803frot_hers
furthers1436493furt_hers
glitches14296653glitche_s
hatchers163113173_hatchers
hitchers16379993_hitchers
ketches164012193_ketche_s
klatches17157133klatche_s
kvetcher2052813kvetcher_
kvetches2053583kvetche_s
latches123320123_latche_s
latchets133410013_latchets
lathers104321883_lat_hers
leacher124014843_leacher_
leaches123319343_leache_s
leathers114215083_leathers
lecher113415853_le_cher_
lechery15257643_le_chery
leches115421313_le_che_s
leeches123911933_leeche_s
letched133912053_letche_d
lethes94818083_let_he_s
letters73819853_let_ters
lunchers13349563_lunchers
lurchers13307153_lurchers
lynchers16285453_lynchers
matchers153012433_matchers
notchers13279423_notchers
patchers153413303_patchers
peachers153213843_peachers
perchers153611523_perchers
pitchers153211483_pitchers
pleaches153210433pleache_s
pleathers1446453pleathers
plenches153110623plenche_s
preachers16339573preachers
quenchers2343173quenchers
reachers133515723_reachers
retches123318513_retche_s
scutchers16175643scutchers
sketcher1735433sketcher_
sketches1746823sketche_s
slatches131511523slatche_s
slathers113914773slat_hers
sleighers1343703sleighers
slithers114212953slit_hers
slouchers14185623slouchers
snatchers14146303snatchers
snitchers14166043snitchers
stitchers14146993stitchers
stretchers1545163stretchers
switchers17146633switchers
teachers133212393_teachers
teethers11328713teet_hers
tethers103815313_tet_hers
thatchers1744573thatchers
trenchers14288073trenchers
twitchers17134533twitchers
vetches153411263_vetche_s
watchers163511793_watchers
welchers16338053_welchers
wenchers16319213_wenchers
wethers135214693_wet_hers
wrenchers17256333wrenchers
wretches16257283wretche_s

Search took 8 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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411617.72019254.0
3Display Results1611610.0602683.3
 (SQL Overall)1786911617.93622516.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.