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

366 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
techier126924(None) 
techie11511721techie_
techies12513601techies
tetchier1336451tetchier
achier113914262_achier
beachier1538802beachier
beechier1535632beechier
decrier102713552decrier
echoer114011102_echoer
etcher113912942etch_er
itchier12247672itchier
leachier1337252leachier
lecher113415852lech_er
meshier123410852meshier
peachier1548622peachier
peckier153910522peckier
reechier1336672reechier
stenchier1445332stenchier
tackier133712522tackier
teacher123714832teach_er
tearier73815612tearier
teched124014432tech_ed
techiest1359832techiest
techily1537122techily
teenier72611142teenier
tentier73815922tentier
terrier73414962terrier
testier74015642testier
tether93716102teth_er
tocher114014912toch_er
torchier1337462torchier
touchier1347382touchier
aerier64823153ae_rier
aether94213673aeth_er
archer115016243arch_er
ashier94714833_ashier
atelier7311623ate_lier
beadier103513913beadier
beakier134012163beakier
beamier113411943beamier
beefier12329093beefier
beerier93613023beerier
belcher143511493belch_er
belier84423563be_lier
bencher144113483bench_er
bendier103111413bendier
beshiver1634483beshiver
bitchier15307733bitchier
botchier15287143botchier
bunchier1536153bunchier
bushier123712813bushier
cahier113615773_cahier
cashier123713323cashier
catchier15329863catchier
catechizer2643143catechizer
cheer105420383__cheer
chicer134513603__chicer
chichier1836023chichier
chider125116053__chider
chief134419483__chief
chiel104918973__chiel
chimer135517203__chimer
chirr105015903__chirr
cockier154013623cockier
crier74724463__crier
cushier123610833cushier
dashier114311183dashier
decayer13339353decayer
deceiver1436233deceiver
decider114213183decider
decker135215993dec_ker
decliner113710843decliner
decoder113712293decoder
decoyer13348683decoyer
decreer10269123decreer
decried112612853decried
decriers11299733decriers
decries103319803decries
deedier93011593deedier
defier105118653de_fier
deifier113013123deifier
denier74420693de_nier
dernier83011943dernier
descrier1157623descrier
dewier104013463de_wier
dicier94416233dic_ier
dickier143512453dickier
dictier103411863dictier
dishier113613403dishier
duchies133312313duchies
duckier143911793duckier
easier64218463_easier
eche97520283_ech_e_
eched116919223_ech_ed
eches106322163_ech_es
eching126315563_eching
echini114710433_echini
echoed125211153_echoed
echoers12459693_echoers
echoes114715523_echoes
echoey14397853_echoey
edgier8469733_edgier
eelier64216463_eelier
eerier64320023_eerier
elmier839813_elmier
envier939673_envier
etched123613703etch_ed
etchers123411293etch_ers
etches114217763etch_es
etching134511843etching
ether84518773_eth_er
fennier10339253fennier
fernier103110823fernier
fetcher153510393fetch_er
fishier13359853fishier
fleshier1435603fleshier
geekier12286393geekier
gemmier12337383gemmier
germier10309543germier
gushier113110073gushier
headier113212953headier
heathier1438343heathier
heavier13429423heavier
heckler16278573heckler
hedgier12367883hedgier
heftier1337203heftier
hempier14319003hempier
herbier1239593herbier
icier74313753_ic_ier
ickier12439923_ickier
incher114114033inch_er
jerkier18407273jerkier
jettier14358693jettier
kerchief2043873kerchief
kickier12349053kickier
kvetchier2141863kvetchier
lacier84020093lac_ier
lathier10310833lathier
leacher124014843leach_er
leadier83212723leadier
leafier10329833leafier
leakier114010993leakier
learier73415663learier
leavier10319993leavier
leched123716003lech_ed
lechers123313963lech_ers
lechery15257643lech_ery
leches115421313lech_es
leching134613653leching
lechwe1435113lechwe_
lechwes1535063lechwes
ledgier9458503ledgier
leerier73111503leerier
leggier9368233leggier
levier94013873le_vier
luckier133811533luckier
luthier1038233luthier
mealier93015903mealier
meatier93214613meatier
menhir1136783menhi_r
merrier92612303merrier
messier93412923messier
metier83517693me_tier
mothier121910213mothier
muckier153411483muckier
mushier123813593mushier
mythier15125183mythier
necker124012793nec_ker
needier84010623needier
nerdier83110353nerdier
nervier10298833nervier
nether94014163neth_er
nettier74211813nettier
newsier10147223newsier
ocher104516103_och_er
pacier105018683pac_ier
patchier15319663patchier
peacher144216073peach_er
peakier134411443peakier
peatier94017233peatier
peched144915343pech_ed
peching154513903peching
pecker144615363pec_ker
peppier10268323peppier
percher143313423perch_er
perkier133813123perkier
peskier13319113peskier
pestier94317403pestier
pettier94213613pettier
pickier153912973pickier
pitchier15368273pitchier
pithier123010293pithier
poachier1556823poachier
pockier153911603pockier
pouchier1546803pouchier
preachier1646923preachier
punchier1536413punchier
pushier123611093pushier
racier85120973rac_ier
reacher123718293reach_er
readier83117423readier
recamier1237603recamier
receiver1337413receiver
rechew14310213rech_ew
reciter94117263reciter
recliner103211913recliner
recoiler103210493recoiler
recover124312623recover
reedier83815303reedier
reefier102912553reefier
reekier113111123reekier
rehire95415863re_hire
reifier103414523reifier
relier65826183re_lier
rentier73618223rentier
replier94214973replier
richer114015043rich_er
rockier134911883rockier
rushier103411973rushier
seamier93114633seamier
seceder10329573seceder
securer958253securer
sedgier9399053sedgier
seedier83513633seedier
seepier92912013seepier
sexier13310683se_xier
shier85428943__shier
sketchier1853413sketchier
starchier1436643starchier
steadier937313steadier
steamier1048303steamier
steelier839193steelier
stemmier1245253stemmier
stickier14229763stickier
stockier14217253stockier
stretchier1544483stretchier
suckier133613973suckier
tache106222373tach_e_
taches114224173tach_es
tachism1478873tachism
tachist12613293tachist
tacker124224503tac_ker
tackler134013323tackler
talkier114011843talkier
tallier72817213tallier
tangier83013903tangier
tardier859719993tardier
tarrier74323173tarrier
tarsier74119253tarsier
tartier74123263tartier
tastier711817093tastier
tattier74216243tattier
tawnier10318463tawnier
teachers133212393teach_ers
teaches122718353teach_es
teaching143612603teaching
tearer64822903te_arer
teaser65421523te_aser
tech95925443tech___
technic1496903technic
technics1585463technics
techno1135953tech_no
technos1236183technos
techs106915833tech__s
techy135612013tech__y
tectite9310583tectite
tectites1039993tectites
tedder83312163te_dder
teddies92711283teddies
teemer85515743te_emer
teener64717503te_ener
teensier835573teensier
teeter65420313te_eter
teether10349693teether
tekkie934203tekkie_
tekkies1035943tekkies
telfer9379893te_lfer
teller63519823te_ller
tellies73820503tellies
telpher1235563telpher
temper103914093te_mper
tempter11358213tempter
tenches123515523tench_es
tender74121843te_nder
tenner64117103te_nner
tennies73017973tennies
tenoner739683tenoner
tenser64919433te_nser
tenter64623933te_nter
tentie62521183tentie_
termer85717253te_rmer
terriers84210823terriers
terries73425633terries
terser67317823te_rser
tester64227153te_ster
tetched133010773tetch_ed
tetchiest1445793tetchiest
tetchily1644123tetchily
tethers103815313teth_ers
tetter64322453te_tter
thatchier1743983thatchier
their85512153t__heir
thewier1336063thewier
thief114516303t__hief
thir76420543t__hi_r
thymier1534393thymier
ticker124321503tic_ker
tickler133612653tickler
tidier73515113t_idier
tier44936143t___ier
tighter112910693tighter
tinier63622233t_inier
tinnier72910143tinnier
tippier113210543tippier
tipsier9268893tipsier
tither94920283tith_er
tochers123413093toch_ers
tonier65520713t_onier
toothier1136423toothier
torchiere1443573torchiere
torchiers1445073torchiers
tother94117143toth_er
toucher124814353touch_er
trashier113210103trashier
treaclier1144153treaclier
trencher13279313trench_er
trendier937913trendier
tressier847963tressier
trickier143010233trickier
trier54328533t__rier
tubbier11237743tubbier
tucker124316953tuc_ker
tuftier1096603tuftier
turfier10249793turfier
tushie939723tushie_
tushies10312163tushies
tweakier1533143tweakier
tweedier1253623tweedier
twier84713293t__wier
twinier1037313twinier
twitchier1753233twitchier
typier1137333t_ypier
vealier102712173vealier
veinier10269583veinier
verier94620963ve_rier
vernier102711273vernier
vichies15310623vichies
wackier16369733wackier
washier133611153washier
wearier103613283wearier
webbier1445423webbier
wedgier12428283wedgier
weedier113810623weedier
weenier103210803weenier
weepier12319273weepier
welcher15319393welch_er
wencher153811133wench_er
wennier10318603wennier
wether123315393weth_er
witchier16307883witchier
withier132910493withier
yachter1534913yachter
yuckier16358533yuckier
zechin20137703zechi_n
zechins21137123zechins
zestier163010223zestier

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 Filter1786911340270.423422437.4
2DLD Change Limit1340273666.51620568.9
3Display Results3663660.1232975.6
 (SQL Overall)1786913667.06225303.2
 
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.