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

205 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
stourie746935(None) 
stoure64814941stour_e
ourie54027302__ourie
scourge1035652scourge
source8410672s_ource
stogie7311322sto_gie
stoolie739722stoolie
store56333812sto_r_e
storied8515162sto_ried
stories7324272sto_ries
stour54916742stour__
stoures74614162stoures
stours65015632stour_s
stoury9529942stour_y
tsouris735152tsouris
bistouries1244473bistouries
bougie93613273_bougie
bourne83714093_bourne
bourse84414333_bourse
corrie83621223_corrie
coterie9417403coterie
courier93617893_courier
course85117783_course
cowrie113814283_cowrie
curie74533043__curie
dourine8311453_dourine
ghoulie1144263ghoulie
gourde8107933_gourde
groupie1045783groupie
houri85915253_houri_
houris94514583_houris
louie55023513_lou_ie
oorie53026363__oorie
roturier836033roturier
satori6415843sato_ri_
satoris7317253sato_ris
sauries72821623s_auries
savourier1242973savourier
savouries1245473savouries
sciurid1044923sciurid
sciurine1045233sciurine
score75526743sco_r_e
scoria8513503sco_ria
scoriae9310903sco_riae
scottie937463scottie
scour75315533scour__
scoured103811153scoured
scourer93910433scourer
scourged1234573scourged
scourger1134723scourger
scourges1136533scourges
scouring112810853scouring
scours84913593scour_s
scouse84113633scou_se
secure8513533secur_e
shore85432653sho_r_e
shortie10411343shortie
silurid837013silurid
snore55424953sno_r_e
snoutier8206973snoutier
softie93312483s_oftie
soiree62919483s_oiree
sonsie6614863s_onsie
sore47059533s_o_r_e
sori46039843s_o_ri_
sorrier72313733s_orrier
sortie63621993s_ortie
souari6311383s_ouari_
souaris7312333s_ouaris
soubise9118793s_oubise
soupier93111753s_oupier
sour45935893s_our__
sourced1038453s_ourced
sources9312173s_ources
sourdine936893s_ourdine
soured74921863s_oured
sourer63620213s_ourer
souring83219063s_ouring
sourish10310693s_ourish
sourly93612213s_ourly
sours55230503s_our_s
souse56530773s_ou_se
splurge1044763splurge
spore75428593spo_r_e
sporule937273sporule
spouse84112513spou_se
spurge93711323s_purge
squire155912463s_quire
staggie9138463staggie
stare54440263st_ar_e
starrier8279463starrier
starve94613743st_arve
stature74410683statur_e
stearic939423stearic
stearin7312003stearin
stearine8311903stearine
steelie7310213steelie
stere55328543st_er_e
steric8317063st_eric
sterile7316603st_erile
stiffie13245773stiffie
stoae55024263sto__ae
stoai55417873sto_ai_
stockier14217253stockier
stodge8369043sto_dge
stodgier1034223stodgier
stogies8413693sto_gies
stoic7317253sto__ic
stoke94922513sto__ke
stole54928813sto__le
stolid74213183sto_lid
stomate9313123stomate
stone55431183sto__ne
stonier72013793sto_nier
stooge73811663sto_oge
stoolies8311083stoolies
stope74727243sto__pe
stopple1156583stopple
storage8310473storage
storax1389783sto_rax
stored75524213sto_red
storer64721673sto_rer
stores65533663sto_res
storey95217613sto_rey
storing83921123sto_ring
stork96819693sto_r_k
storks106115953sto_rks
storm76520403sto_r_m
stormed1039043sto_rmed
stormier1036103stormier
storms85814633sto_rms
stormy115510733sto_rmy
story86723033sto_r_y
stotin63215063sto_tin
stound7399903stou_nd
stounded10276213stounded
stounds8377823stounds
stoup75517073stou__p
stoups85313273stou_ps
stout57434053stou__t
stouten7307333stouten
stouter74012053stouter
stoutish1145903stoutish
stoutly1035833stoutly
stouts65019003stou_ts
stove85220253sto__ve
stowage1136703stowage
stria55723213st__ria
striae65422273st__riae
stride75420963st__ride
strife95318363st__rife
strike105619733st__rike
strip77524343st__rip
stripe85822443st__ripe
strive95020963st__rive
strumae9368093strumae
studdie9195273studdie
studied9268693st_udied
studier82510053st_udier
studies82413863st_udies
studio7247133st_udio
stupe75217753st_u_pe
stupid937593st_upid
sturdied10215963st_urdied
sturdier9216963st_urdier
sturdies92110273st_urdies
sturdy1037043st_urdy
sturt56028963st_ur_t
sturts63915143st_urts
stymie1137623st_ymie
sure45447413s__ur_e
surge65027693s__urge
suture6313203sutur_e
swore84920823swo_r_e
synurae1044253synurae
taurine7311363_taurine
toonie63617993_toonie
tore47359323_to_r_e
tori47542153_to_ri_
toric76529313_to_ric
tories65435883_to_ries
torii55521593_to_rii
torrid7311853_torrid
torse55833333_to_rse
torte55431703_to_rte
touche114916173_touche
toughie1187593_toughie
toupee8316133_toupee
tour45530383_tour__
toured74216153_toured
tourer64115073_tourer
touring82915193_touring
tourism939423_tourism
tourist7313203_tourist
tourney1036273_tourney
tours55325893_tour_s
touse55430673_tou_se
tousle64514653_tousle
touzle15429003_touzle
towie85821873_to_wie
townie93312303_townie
tsooris734693tsooris
tsoris63411193tso_ris
tsuris62710203_tsuris
tzuris15286913_tzuris

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.390458182.1
2DLD Change Limit1340272056.32621186.7
3Display Results2052050.0633254.0
 (SQL Overall)1786912056.77926359.5
 
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.