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

140 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
standby133442(None) 
standbys1443201standbys
sandy94221132s_and_y
shandy134710032shand_y
staidly1136682staidly
stand65923282stand__
standee83514512standee
stander84316162stander
stands75118052stand_s
standup1034352standup
bandy114824183_band_y
blandly1336043blandly
brandy124712063brand_y
candy115119823_cand_y
dandy104416703_dand_y
grandly1238743grandly
handy125520873_hand_y
pandy115021173_pand_y
randy95022083_rand_y
sadly94519123s_a_dly
sand55338473s_and__
sandal73317283s_andal
sandbag11106243s_andbag
sandbar10108193s_andbar
sandbox1744803s_andbox
sandbur10105353s_andbur
sanded84920613s_anded
sander74828533s_ander
sandfly1435643s_andfly
sandhi1038193s_andhi
sands65228583s_and_s
sanely93114613s_anely
sanity9316203s_anity
scabby1535503sca_bby
scandal1038673scandal
scandia1038063scandia
scandic1237003scandic
scantly12419553scantly
scanty114014663scan_ty
shabby1635803sha_bby
shady125416513sha_d_y
shanny124110093shan_ny
shantey134210043shantey
shanty124715123shan_ty
shindy13449323shind_y
skanky12476963skan_ky
slander84015443slander
slangy105411393slan_gy
slantly10399323slantly
slanty95114843slan_ty
soundly1136683soundly
spandex1735833spandex
spangly1336473spangly
spendy124911143spend_y
spindly13257383spindly
stab67329933sta__b_
stably113314123sta_bly
stabs76221383sta__bs
staddle9288093staddle
stade64825303sta_d_e
stades74626243sta_des
stadia7312143sta_dia
stagey105915583sta_gey
staggy115510393sta_ggy
stagily1139053stagily
stagy96618893sta__gy
staid66722083staid__
staider83912613staider
stalely1039213stalely
stalky13499303sta_lky
stance84316913stan_ce
stances93715963stances
stanch113812373stan_ch
stanchly1644443stanchly
standard1046253standard
standaway1642653standaway
standees93310143standees
standers93514303standers
standing103413633standing
standish1238543standish
standoff1543993standoff
standout948663standout
standpat1145723standpat
standups1143963standups
stane55933003stan__e
staned74824643stan_ed
stanes64933403stan_es
stang66424683stan__g
stanged94113843stanged
stangs75018163stan_gs
stanine73417073stanine
staning83922243staning
stank95823303stan__k
stanks104917703stan_ks
stannary1144613stannary
stannic936663stannic
stannum944643stannum
stanol6310723stan_ol
stanols739733stanols
stanza1537073stan_za
stanzas1636363stanzas
starchy15286743starchy
stardom1037763stardom
starkly14277033starkly
starry94911673sta_rry
startsy10536703startsy
statedly1245833statedly
stately10310223stately
statusy10455423statusy
stay78333723sta___y
steady103510203stead_y
stenchy15256213stenchy
stenoky1444253stenoky
stingy105213203stin_gy
stinky134611073stin_ky
stodgy11415733st_odgy
stoney96217353ston_ey
stonily1049433stonily
stony85818643ston__y
strand74514823strand__
stranded102710813stranded
strander97112063strander
strands83711953strand_s
stubby1345043st_ubby
studly10397693st_udly
study94411793st_ud_y
sturdy1037043sturd_y
sundry1057943s_undry
swabby1634353swa_bby
swanky16447973swan_ky
swanny12336823swan_ny
swingby16343893swingby
tabby125213893_ta_bby
tandem9311403_tandem
tangly104413913_tangly
tangy94519933_tan_gy
tannoy958353_tannoy
tansy84514933_tan_sy
tardy94720463_tard_y
tawdry13395253_tawdry

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.420425454.8
2DLD Change Limit1340271406.48620664.0
3Display Results1401400.0463043.5
 (SQL Overall)1786911406.95225703.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.