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

101 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
standup103435(None) 
standups1143961standups
sannup836562s_annup
sendup9106342s_endup
stackup1533742stackup
stand65923282stand__
standby1334422standby
standee83514512standee
stander84316162stander
standout948662standout
stands75118052stand_s
stannum944642stannum
startup934962startup
hangup1277293_hangup
roundup1044063roundup
sand55338473s_and__
sandal73317283s_andal
sandbur10105353s_andbur
sanded84920613s_anded
sander74828533s_ander
sandhi1038193s_andhi
sands65228583s_and_s
sandy94221133s_and_y
sannop837373s_annop
sannups934463s_annups
santur6311273s_antur
scaleup1134483scaleup
scandal1038673scandal
scandia1038063scandia
scandic1237003scandic
scandium1365693scandium
scaup95515993sca__up
sendups10115193s_endups
shaduf1337063sha_duf
shakeup1632763shakeup
shandy134710033shand_y
shapeup1443293shapeup
slander84015443slander
smashup1443453smashup
spandex1735833spandex
speedup1272983speedup
stackups1643313stackups
staddle9288093staddle
stade64825303sta_d_e
stades74626243sta_des
stadia7312143sta_dia
stadium1038073stadium
staid66722083staid__
staider83912613staider
staidly1136683staidly
stamp95217363sta__mp
stance84316913stan_ce
stances93715963stances
stanch113812373stan_ch
standard1046253standard
standbys1443203standbys
standees93310143standees
standers93514303standers
standing103413633standing
standish1238543standish
standoff1543993standoff
standouts1044983standouts
standpat1145723standpat
standpipe1443343standpipe
stane55933003stan__e
staned74824643stan_ed
stanes64933403stan_es
stang66424683stan__g
stanged94113843stanged
stangs75018163stan_gs
stanhope1344273stanhope
stanine73417073stanine
staning83922243staning
stank95823303stan__k
stanks104917703stan_ks
stannic936663stannic
stannous846443stannous
stannums1043803stannums
stanol6310723stan_ol
stanols739733stanols
stanza1537073stan_za
stanzas1636363stanzas
stardom1037763stardom
stardust946093stardust
startups1033893startups
statue66015323sta_tue
status65515213sta_tus
stickup1533853stickup
stirrup943003stirrup
stoup75517073st__oup
strand74514823strand__
stranded102710813stranded
strander97112063strander
strands83711953strand_s
sunup7313053s_un_up
takeup1234583_takeup
tandem9311403_tandem
tendu67216003_tendu_
tendus75111183_tendus
tuneup835203_tuneup
windup1235383_windup

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271017.37618170.7
3Display Results1011010.0303366.7
 (SQL Overall)1786911017.81222873.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.