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

145 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
employ134649(None) 
employe1476361employe
employs1455521employs
amply125012912ampl_y
coemploy1743322coemploy
deploy1237582deploy
emboly1336722emboly
empery1348682empery
employed1654942employed
employee1555202employee
employer1564712employer
employes1555942employes
empty1247762emp_ty
imply124911842impl_y
ploy96123602__ploy
reemploy1543342reemploy
alloy85519973_alloy
ample94720303ampl_e
ampler104313303ampler
amplify1744083amplify
apply125111393appl_y
byplay1634193byplay
cloy96623833__cloy
coemploys1842763coemploys
complot13310683complot
comply152810383compl_y
coplot10518273coplot
damply14337893dampl_y
deeply1257013deepl_y
deploys1336523deploys
dimply14339743dimpl_y
diploe9810153diploe
disemploy1752563disemploy
early85324123earl_y
ecology13218823ecology
eely77725213e_el_y
elmy95616793e__lmy
embay123410603em_bay
emblem1237583emblem
embody1435033embody
emboli1037483emboli
embow1297563em_bow
embryo1363963embryo
emerod9139213emerod
emery104814333em_ery
emmy116013243em__my
empale102611263empale
empaled12288953empaled
empaler11288353empaler
empales112411433empales
empathy1743483empathy
emperor1155483emperor
empire1039323empire
emplace1338263emplace
emplane11410013emplane
employees1653393employees
employers1644123employers
employing1765343employing
emptily1445813emptily
emulous937343emulous
endplay13103963endplay
enjoy1545963e_njoy
enology11239813enology
envoy1156713e_nvoy
ephod1139123e_phod
ephor10310013e_phor
epilog976463epilog
epos66723733e_p_os
epoxy17465773e_poxy
espy969373esp__y
etalon648973etalon
eulogy1035633e_ulogy
euphony1545403euphony
euploid1038963euploid
euploidy1454623euploidy
evilly1236593evilly
expiry1834653expiry
explode1745963explode
exploit1648623exploit
explore1646613explore
expo1349183exp_o_
expos1449203exp_os
gemology1546163gemology
haply135915063hapl_y
hempy154912763hemp__y
hiply134113613hipl_y
impled113812513impled
implode12156103implode
implore11176703implore
improv1344643improv
jimply20397483jimpl_y
limply133810033limpl_y
malmy124816343_malmy
malty106721703_malty
mealy104422183meal_y
medley1298333medley
mellow114112223mellow
melody1237203_melody
melon73922083_melon
melty104918363_melty
merlon83012353merlon
merlot83217603merlot
milky144014443_milky
milo65536103_milo_
milos75428013_milos
milty104720073_milty
misemploy1852283misemploy
moldy115014653_moldy
molly105222493_molly
moly96031913_mol_y
muley104819283_muley
peplos101211543peplos
pimply15329213pimpl_y
play95928983__play
plod76723273__plod
plop86625743__plop
plot66141233__plot
plow95923233__plow
ploys105816593__ploys
ply86323553__pl_y
poly96235153__poly
redeploy1453173redeploy
reemploys1653003reemploys
replay113412923replay
replot83818593replot
replow114210343replow
reply104015853repl_y
rumply13348573rumpl_y
semilog1046003semilog
semple103212753sempl_e
sepoy10314303sep_oy
simply133010523simpl_y
smelly114110363smelly
smiley114012303smiley
splay105816043_splay
teapoy1138113teap_oy
temblor1144093temblor
templar1145643templar
temple102811333templ_e
templed12278553templed
temples112610893temples
templet112712003templet
tempo95214973temp_o_
tempos103812293temp_os
tepoy10312163tep_oy

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161455.31321215.1
3Display Results1451450.0463152.2
 (SQL Overall)1786911455.49932495.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.