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

134 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
satrapy1249793(None) 
satrap86212551satrap_
satraps95011641satraps
astray95615542astra_y
sarape84817572sa_rape
satay84718462sat_a_y
strap77925262s_trap_
strappy14205262s_trappy
straps87721782s_traps
strawy1210312822s_trawy
stray88525572s_tra_y
stripy115812742s_tripy
array86317143_arra_y
ashtray13805553ashtra_y
astral66919283astra_l
astrally1148883astrally
astrals75515243astrals
atap66722453_at_ap_
ataps76414833_at_aps
ataraxy1743983_ataraxy
ataxy1537313_at_axy
atopy106813393_at_opy
atrip75315753_atrip_
atrophy1546183_atrophy
betray111511443betra_y
caltrap11297943caltrap_
caltraps12327253caltraps
cantrap113310283cantrap_
cantraps12319113cantraps
catnap1098383catnap_
catnaps1197033catnaps
datary10310243dat_ary
entrap8710563entrap_
entraps9109763entraps
entropy1247353entropy
estray95713333estra_y
grapy115416433__grapy
harpy136418213ha_r_py
hatrack1638213hatrack
isotropy1344233isotropy
mantrap11379823mantrap_
mantraps12298063mantraps
matrass939403matrass
paraph13311263pa_raph
ratany93411873rat_any
rattrap945263rattrap_
rattraps1044823rattraps
sabra75317853sabra__
sabras85116363sabra_s
sacra74516993sacra__
sacral83414413sacra_l
sacrals93311793sacrals
salary9515213sa_lary
sappy125413473sa__ppy
saran53730303sa_ra_n
sarans64224433sa_rans
sarapes94617743sa_rapes
sarky125521783sa_r_ky
sashay1238363sasha_y
sassaby1244003sassaby
satang75711563sat_ang
satara6315533sat_ara
sataras7315063sataras
satays94411683sat_ays
satiably1337823satiably
satiate7315403satiate
satiety1038203satiety
satiny93817983sat_iny
satisfy1344183satisfy
satrapies1147713satrapies
saturant8410643saturant
saturate8312813saturate
saury84317223saur__y
scrap97120403s_crap_
scrape105917573s_crape
scrappy16234473s_crappy
scraps106017243s_craps
seatrain847923seatrain
serape84818413s_erape
seraph114011163s_eraph
sharpy145211033shar_py
sirupy11377053s_irupy
soapy106114783s__oapy
spray106720063s_pra_y
stagy96618893s_t_agy
staph104314653s_t_aph
starchy15286743starchy
starkly14277033starkly
starry94911673star_ry
startsy10536703startsy
statuary1144033statuary
stay78333723s_t_a_y
steady103510203s_teady
steamy115112373s_teamy
strafe95215983s_trafe
strain64919573s_train
strait64025893s_trait
strake104017393s_trake
strand74514823s_trand
strang75718313s_trang
strass67117223s_trass
strata63616283s_trata
strath93216373s_trath
strati63518903s_trati
straw813321293s_tra_w
straws98718673s_traws
strays96417933s_trays
streaky14447813s_treaky
streamy12509483s_treamy
strep77120853s_trep_
streps86218063s_treps
strip77524343s_trip_
stripe85822443s_tripe
strips85719653s_trips
stript85222193s_tript
strop77422243s_trop_
stroppy14205093s_troppy
strops86220383s_trops
stroy87720393s_tr_oy
stumpy13458133s_tumpy
sunray9310123sunra_y
sutra54217933sutra__
sutras64818593sutra_s
syrupy14285823s_yrupy
therapy1536613therapy
trampy13499253__trampy
trap67532803__trap_
traps75727483__traps
trapt76433393__trapt
tray77632593__tra_y
watap102111673wat_ap_
watape11208483wat_ape
wataps11248683wat_aps
wattape12135383wattape

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.1561145455.1
2DLD Change Limit1340271346.87619492.0
3Display Results1341340.0462913.0
 (SQL Overall)1786911347.07825246.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.