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

179 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
typists123617(None) 
typist1139821typist_
lyrists1036962lyrists
papists112110452papists
rapists92510752rapists
stylists11207022stylists
tanists7313652tanists
tapises92914012tapises
theists1039152theists
tubists9288322tubists
twists9549752t_wists
typesets1343212typesets
typiest1238202typiest_
utopists1045772utopists
ageists848493ageists
agists75713173_agists
aorists74215833aorists
artists74215593artists
aspises9611643aspises
assists738473assists
atavists1137583atavists
atheists1138713atheists
atomists102610963atomists
aurists74615783aurists
autists73814853autists
baptists1236723baptists
bemists113410703bemists
bypass1345043bypas_s
bypast13117373bypast_
chymists18285603chymists
cists76624533__cists
copyists1545993copyists
cubists11359023cubists
cyclists1545713cyclists
cysts105912773cy__sts
deists74916433_deists
delists84414173delists
depicts12358463depicts
desists83611723desists
dynasts1155103dynasts
egoists887073egoists
enlists749393enlists
exists134710913_exists
feists94915313_feists
fists85527543__fists
flypasts1662433flypasts
foists95413983_foists
gists66026193__gists
grists74716483_grists
gypsies1335953gypsies
harpists1338103harpists
heists96814633_heists
hists86328373__hists
hoists95516023_hoists
holists104413963holists
hygeists1543543hygeists
hymnists1644903hymnists
idylists1244123idylists
imposts11269003imposts
insists739083insists
joists134711033_joists
jurists14409123jurists
kists95822113__kists
lapises93513463lapises
legists899593legists
lists56628693__lists
lutists73810273lutists
lyrisms1235653lyrisms
lyrist9312293lyrist_
maists85817573_maists
mists76633903__mists
monists93614783monists
mysosts1234543mysosts
nudists8356833nudists
oboists937903oboists
odists749853_odists
papisms13238543papisms
papist102618753papist_
pasts75936503__pasts
pests75933273__pests
pints75936223__pints
pipits104713063pipi_ts
pisos76021063__pisos
piss65033333__pis_s
piste75824603__piste
pistes85325633__pistes
pits66348743__pi_ts
posts75228783__posts
purists94014073purists
racists92613323racists
rapist82520673rapist_
relists73817053relists
repasts93611933repasts
resists74414923resists
riposts9279403riposts
sadists83310853sadists
schists1248543schists
sexists14267673sexists
shists96515113_shists
sophists1347293sophists
spirts85317133_spirts
spits74429553_spi_ts
statists8310163statists
stylises11188943stylises
stylist102110283stylist_
stypsis1245243styp_sis
stypsises1443423stypsises
tachists1348183tachists
taints64520533t_aints
tamises92715973tamises
tanist6324603tanist_
tapirs84113173tapi_rs
tapis75028863tapi__s
tappets113610013tappets
tempests1234443tempests
tennists8297793tennists
tests56530193t__ests
theisms1237763theisms
theist9314763theist_
thirsts1036243thirsts
thrifts1335523thrifts
thrusts10226523thrusts
tilts55325613t__ilts
tints56030923t__ints
tipcats1137103tipcats
tipis76019923tipi__s
tippets11339373tippets
titlists837293titlists
tits46145043t__i_ts
toasts65914993t_oasts
toits55327473t_oi_ts
topics104714583topi_cs
topis76025833topi__s
topmasts1244973topmasts
tourists838313tourists
traits65121983trai_ts
triste63818643t_riste
tropisms1247723tropisms
truisms9106823truisms
trusts64714433t_rusts
trypsins1344903trypsins
trysts9448793t_rysts
tsarists857303tsarists
tubaists1055103tubaists
tubist83013163tubist_
tupiks1235493tupi_ks
turista737443turista
turistas846693turistas
twist86820983t_wist_
twisty12426863t_wisty
twits86015793t_wi_ts
tympanists1743103tympanists
typecasts1642823typecasts
types105721063typ__es
typeset1267743typeset
typhons1537083typhons
typhous1566323typhous
typhus14395713typ_hus
typhuses1643763typhuses
typic124511963typi__c
typical1436343typical
typier1137333typi_er
typifies1644963typifies
typify1734523typi_fy
typing124110583typi_ng
typos106015813typ__os
typps12549303typ__ps
tyrants1037453tyrants
tzarists1755693tzarists
utopisms1245413utopisms
utopist938693utopist_
verists103613673verists
vibists1256483vibists
waists97415453_waists
whists124613813_whists
wists86728523__wists
wrists95415643_wrists
xysts15558123xy__sts
yeasts96413053_yeasts

Search took 7 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.406440125.6
2DLD Change Limit1340271795.67323625.4
3Display Results1791790.0802237.5
 (SQL Overall)1786911796.15929013.0
 
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.