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 “straitest” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
straitest94917(None) 
staidest939802st_aidest
straightest1564342straightest
straiten838612straite_n
straitens946232straitens
straiter8311782straite_r
straitness1046292straitness
straits74916322strait_s_
strangest103210842strangest
strawiest1237212strawiest
striates83417082striates_
strictest1147292strictest
tritest7315272_tr_itest
abstractest1553623abstractest
adroitest1044763adroitest
frailest1139493_frailest
iratest7312483_ira_test
saltest71916513s__altest
sarkiest123615063sarki_est
scantest101710183s_cantest
scariest101615943scari_est
sedatest9249393seda_test
seriates82620673seriates_
slatiest82616263s_latiest
smartest10310183s_martest
sorites73825243sor_ites_
sorriest8413883sorri_est
spriest92718643spr_i_est
sprites94220333spr_ites_
squattest1844613squattest
stablest103312943st_ablest
stactes91914633st_actes_
stagiest91613403st_agiest
staithes1138953st_aithes_
stalest73720173st_a_lest
starkest1239723st_arkest
starriest9159763starriest
states64337083st_a_tes_
statist7317723st_a_tist
steadiest1038513steadiest
steamiest1138403steamiest
steatites939843steatites_
sternites9310073sternites_
stipites1039653stipites_
stolidest1046113stolidest
stoniest8413543stoni_est
stormiest1137003stormi_est
stoutest837613st_outest
strafes104516003stra_fes_
straight1249183strai_ght
straights1345813straights
strained9412253straine_d
strainer8512223straine_r
strainers9510383strainers
strains74218153strai_ns_
strait64025893strai___t
straitened1143783straitened
straitly1136563strait_ly
strakes114218073stra_kes_
stranges94516763stranges_
strapless1135793strapless
strappiest1444373strappiest
strasses81311443strasses_
stratas73013583stra_tas_
strategist1154773stra_tegist
strategy1244363stra_tegy
straths102711723stra_ths_
stratus73011733stra_tus_
streakiest1444763streakiest
streamiest1245113streamiest
striate74218953striate__
striated93414153striate_d
strident9310173str_ident
strides84520393str_ides_
strifes104716583str_ifes_
strikes114719093str_ikes_
stripes95320573str_ipes_
stripiest1138013stripiest
strives104119373str_ives_
strongest10338293strongest
stupidest1244143stupidest
sturdiest10207393sturdi_est
stylites11168693stylites_
surfiest112414433surfi_est
surliest82416913surli_est
sweatiest1238413sweatiest
tartest72517533_t_artest
tartiest82718313_tartiest
tautest72612443_t_autest
traitress944403_traitress
traits65121983_trait_s_
trapnest10310923_trapnest

Search took 9 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 Filter1786911486410.436409841.7
2DLD Change Limit148641927.70319296.5
3Display Results92920.0332787.9
 (SQL Overall)178691928.17221866.3
 
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.