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

137 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
straiten83861(None) 
straitens946231straitens
straiter8311781straiter
straighten1454152straighten
strain64919572strai__n
strained9412252strained
strainer8512222strainer
strait64025892strait__
straitened1143782straitened
straitest949172straitest
straitly1136562straitly
straits74916322strait_s
striate74218952striate_
striated93414152striated
striates83417082striates
striven103910752str_iven
distraite10611483distraite_
ratten64217383__ratten
seriate73722473seriate_
seriated92717023seriated
seriates82620673seriates
shaitan1036893s_haitan
shriven13379653shr_iven
smarten9348863s_marten
sorites73825243sor_ites
sprain83614863sprai__n
sprained1138433sprained
sprite84421773spr_ite_
sprites94220333spr_ites
stacte82113913st_acte_
stactes91914633st_actes
staider83912613st_aider
stain55727943st_ai__n
stained84215343st_ained
stainer73614923st_ainer
staithe1037723st_aithe
staithes1138953st_aithes
stamen84115943st_a_men
started84217323st_arted
starter73817883st_arter
state56237333st_a_te_
stated75427833st_a_ted
stater64427563st_a_ter
states64337083st_a_tes
statin63921473st_a_tin
station72717243st_ation
steatite8310583steatite_
steatites939843steatites
sternite8310543sternite_
sternites9310073sternites
stipites1039653stipites
stouten7307333st_outen
strafe95215983stra_fe_
strafed114413333stra_fed
strafer103912463stra_fer
strafes104516003stra_fes
straight1249183straight
straighted1544863straighted
straightens1563693straightens
straighter1444493straighter
strainers9510383strainers
straining10410563straining
strains74218153strai_ns
straitening1243663straitening
straitness1046293straitness
strake104017393stra_ke_
straked125415343stra_ked
strakes114218073stra_kes
stranded102710813stranded
strander97112063strander
strange85416343strange_
stranger94715103stranger
stranges94516763stranges
strapped1357823strapped
strapper1258093strapper
strasses81311443strasses
strata63616283stra_t_a
stratal72710603stra_tal
stratas73013583stra_tas
strategy1244363stra_tegy
strath93216373stra_t_h
straths102711723stra_ths
strati63518903stra_t_i
stratify1445703stratify
stratum9318253stra_tum
stratus73011733stra_tus
strawed114813613stra_wed
strawier1137493strawier
strayed114513283stra_yed
strayer104312503stra_yer
strette7310763strette_
striae65422273str_iae_
striata7379953striat_a
striating10914193striating
striation9313483striation
striatum1044473striatum
stricken1436893stricken
stricter1039423stricter
stridden1044273stridden
stride75420963str_ide_
strident9310173str_ident
strider84315723str_ider
strides84520393str_ides
strife95318363str_ife_
strifes104716583str_ifes
strike105619733str_ike_
striker113714173str_iker
strikes114719093str_ikes
stripe85822443str_ipe_
striped105214363str_iped
striper94514793str_iper
stripes95320573str_ipes
strive95020963str_ive_
strived114713663str_ived
striver104315203str_iver
strives104119373str_ives
strucken1444323strucken
strunted957243strunted
strutted946343strutted
strutter846503strutter
stylite10219613stylite_
stylites11168693stylites
tauten64311893_t_auten
traiked123310453_traiked
trailed83415673_trailed
trailer73015393_trailer
train56529113_trai__n
trained84117203_trained
trainee72817793_trainee
trainer73316793_trainer
trainmen1046153_trainmen
trait56940843_trait__
traitor7310123_traitor
traits65121983_trait_s
trite54730033_tr_ite_
triter65120593_tr_iter
triton63914893_tr_iton

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 Filter1786911461620.453394461.4
2DLD Change Limit1461621376.61022112.3
3Display Results1371370.0462978.3
 (SQL Overall)1786911377.10925135.9
 
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.