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

139 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
upgirt911726(None) 
ungirt71112711ungirt
upgird10103931upgird
begirt9412682begirt
engirt71112612engirt
girt56646422__girt
spirt75032952sp_irt
ungird887972ungird
updart9310742updart
upgirds11103072upgirds
uplift114610652uplift
uplit76020802upli_t
uptilt8410802uptilt
agist66325583_agist
airt45757783__airt
apart74330673ap_art
aport75432173ap_ort
begird1036823begird
bogart9617193bogart
busgirl1044143busgirl
digit73825273digi_t
dirt55550383__dirt
engird8126973engird
flirt87424753_flirt
gift86735793__gift
gilt56348543__gilt
gird65424993__gird
girl56226553__girl
girn56026863__girn
giro55828633__giro
girth95618843__girth
girts65423623__girts
gist56046763__gist
git46266053__gi_t
grit55247243__grit
hegira1036523hegira
legist71315253legist
legit61323503legi_t
paint75443693_paint
pair66031513_pair_
pairs75325833_pairs
part65967463_p_art
peart76440753_peart
pert66759323_p_ert
pint66963173_p_int
pirn67128373_p_irn
pit56471923_p_i_t
point75338733_point
port66059633_p_ort
print74837463_print
puggry13374823puggry
purist85525053purist
quirt144624233_quirt
regilt71217493regilt
seagirt8310153seagirt
shirt84533903_shirt
skirt95624663_skirt
spait75631603spai_t
speir75315363speir_
speirs85013233speirs
spigot9312603spigot
spilt75532223sp_ilt
spire75828693sp_ire
spirit83519923sp_irit
spirts85317133sp_irts
spiry105017353sp_iry
spit65545083sp_i_t
splint85223283splint
split75729013spli_t
spoilt85016593spoilt
sport75935983sp_ort
sprint84526793sprint
sprit76736403spri_t
spurt77227983sp_urt
squirt153812933squirt
support11310523support
umpire1047893umpire
unfit84518563unfi_t
unfixt16398423unfixt
ungirds9105303ungirds
ungot61718063ung_ot
unhurt9311253unhurt
unit45140073u_ni_t
unlit55025463unli_t
unmixt15378703unmixt
unwit84417523unwi_t
upbeat10911513upbeat
upbind11246313upbind
upbore10247883upbore
upbuilt1144043upbuilt
upcast102710093upcast
upcourt1146103upcourt
upcurl1034963upcurl
updarts1034203updarts
updive1234903updive
updry1135483up_dry
upgaze1833543upgaze
upgirded1342333upgirded
upgoing1135353upgoing
upgrew1233653upgrew
upgrow1234273upgrow
uphill11106173uphill
uplifts12424773uplifts
uplight13167363uplight
uplink12388713uplink
upmost1068193upmost
upper93714263upper_
uppers102912293uppers
uppile10178503uppile
upping114013703upping
uppish1336633uppish
uppity1335103uppity
upright13178293upright
uprise82313693uprise
uproot8314123uproot
upsent83314063upsent
upset73222593up_set
upshift1545113upshift
upshot1138453upshot
upside9289803upside
upsize17267303upsize
upstart9159753upstart
upstir835383upstir_
upstirs935293upstirs
uptick1436763uptick
uptight13176033uptight
uptilts934733uptilts
uptime1067673uptime
uptore8279453uptore
uptorn8268093uptorn
upturn8286243upturn
upwaft1444943upwaft
upward12147163upward
upwind12255823upwind
urgent73816043urgent
urger64116473urger_
urgers73313623urgers
urging83413123urging
yogurt1037823yogurt

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161394.64024292.2
3Display Results1391390.0304633.3
 (SQL Overall)1786911395.04635412.4
 
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.