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

153 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
statusy1045542(None) 
status65515211status_
startsy10536702startsy
stately10310222stately
states64337082states_
statism9412282statism
statist7317722statist
stats55933362stat_s_
statuary1144032statuary
statue66015322statu_e
statued8459892statued
statues74614902statues
stature74410682stature
statuses8409542statuses
statute7419322statute
stratus73011732stratus_
estates74520183estates_
etatism9610293etatism
etatist7415033etatist
flatus94310783flatus_
hiatus938223hiatus_
meatus85112923meatus_
patsy105717203_pat_sy
sassy85813813s_a_ssy
satay84718463s_at_ay
satays94411683s_atays
sates54949323s_ates_
satiny93817983s_atiny
satis55633683s_atis_
satisfy1344183s_atisfy
saucy104615163s_a_ucy
saury84317223s_a_ury
scats75930603scat_s_
scatts85914663scatts_
scatty115310653scat_ty
seats54844343seat_s_
shamus114112813shamus_
situs55019233s_itus_
skates104219403skates_
skats94621543skat_s_
slates64934063slates_
slatey95417063slat_ey
slats55436903slat_s_
slaty86523153slat__y
snafus936743snafus_
snatchy15355293snatchy
snaths95112913snaths_
spates85028173spates_
spats75031383spat_s_
spatula935893spatula
stably113314123sta_bly
stabs76221383sta_bs_
stacks124317263stacks_
stactes91914633stactes_
stades74626243stades_
staffs12349753staffs_
stages75629493stages_
stagey105915583sta_gey
staggy115510393sta_ggy
stagily1139053stagily
stags66226743sta_gs_
stagy96618893sta__gy
staidly1136683staidly
staigs75414813staigs_
stains64923653stains_
stairs65416333stairs_
stakes103927293stakes_
stalely1039213stalely
stales65538293stales_
stalest73720173stalest
stalks104614553stalks_
stalky13499303sta_lky
stalls64019933stalls_
stamps105614023stamps_
standby1334423standby
stands75118053stands_
stanes64933403stanes_
stangs75018173stangs_
stanks104917703stanks_
stapes85028733stapes_
staphs114411033staphs_
starchy15286743starchy
stardust946093stardust
stares66038753stares_
starkly14277033starkly
starry94911673sta_rry
stars55836573sta_rs_
starts65423123starts_
startup934963startu_p
startups1033893startups
stases64225563stases_
stash84916973sta__sh
stasis63116873stasis_
stat47352693stat___
statal61613223stat_al
statant7313123statant
state56237333stat__e
stated75427833stat_ed
statedly1245833statedly
stater64427563stat_er
staters73922343staters
static83118683stat_ic
statice92614033statice
staticky1743233staticky
statics93314533statics
statin63921473stat_in
stating83725163stating
statins73719773statins
station72717243station
statisms1039543statisms
statists8310163statists
stative102612933stative
stator64015483stat_or
stators73915583stators
statures83711113statures
statutes8368893statutes
statutory1242413statutory
staves94525193staves_
stay78333723sta___y
stays86022023sta_ys_
stets55423913stet_s_
stithy12398213stit_hy
stoats65117483stoat_s_
stots54828553stot_s_
stotts64612863stotts_
stoury9529943st_oury
stoutly1035833stoutly
stouts65019003stouts_
stratas73013583stratas_
strategy1244363strategy
straths102711723straths_
stratify1445703stratify
stratous8410703stratous_
stratum9318253stratu_m
stratums10266803stratums
struts65616803struts_
study94411793s__tudy
stylus9397463stylus_
swaths125312643swaths_
swats85726863swat_s_
tabus74820923_tabus_
talus55423263_talus_
tansy84514943_ta_nsy
tates55444983_tates_
tatouay1044113_tatouay
tats46858133_tat_s_
tatty84720183_tat_ty
taus46342733_ta_us_
tautly9499503_tautly
tauts56125513_tauts_
taxus125512483_taxus_
tutus55214813_tutus_
vatus86114643_vatus_

Search took 10 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.403443402.0
2DLD Change Limit1340271539.28314437.9
3Display Results1531530.0463326.1
 (SQL Overall)1786911539.73218361.2
 
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.