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 “ungirds” 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
ungirds910530(None) 
engirds995051engirds
ungird887971ungird_
upgirds11103071upgirds
begirds1134882begirds
engilds974862engilds
engird8126972engird_
girds74816992__girds
sunbirds1143902sunbirds
unbinds10267352unbinds
ungirded1136082ungirded
ungirt71112712ungir_t
unguards1053982unguards
unwinds11286732unwinds
upgird10103932upgird_
angers75222543anger_s
anginas8310953anginas
angoras8811363angoras
begird1036823begird_
birds85421333__birds
busgirls1142653busgirls
cairds96411513_cairds
engild8107613engild_
engines81114463engines
engirded1143973engirded
engirdle1043223engirdle
engirdles1142623engirdles
engirt71112613engir_t
entires71517783entires
enviros1034913enviros
enwinds11255553enwinds
fungoids1343993fungoids
gids65933733__gi_ds
gilds75417523__gilds
gird65424993__gird_
girls64518393__girls
girns64516803__girns
giros65722653__giros
girts65423623__girts
grids75321393__grids
gunfires1235063gunfires
hangbirds1642933hangbirds
hegiras1136103hegiras
hungers114013303hunger_s
infirms1245563infirms
innards837153innards
inwards1138343inwards
inwinds11216273inwinds
kingbirds1782523kingbirds
lairds74711613_lairds
lungers83817093lunger_s
lungis77113023lungi__s
naiads739013_naiads
nairas6312773_nairas
nairus639143_nairus
nards65928463_n_ards
nerds65719253_n_erds
noirs55615463_noir_s
nurds65518523_n_urds
onwards1137173onwards
pongids11347413pongi_ds
regards94112563regards
regilds996673regilds
shairds11216263shairds
songbirds1342773songbirds
sunbird1044743sunbird_
sunwards1236443sunwards
thirds10438603_thirds
umpires1137813umpires
unaired82916013unaired
unais53420773unai__s
unarms839243un_arms
unbars82113033unbar_s
unbends10236993unbends
unbid83214643unbi_d_
unbind93011433unbind_
unbuilds1143153unbuilds
uncials92510523uncials
uncinus937403uncinus
uncorks1337443uncorks
uncurbs1134913uncurbs
uncurls937123uncurls
underdo937363underdo
undergirds1344453undergirds
undid72415363undi_d_
undies73821963undi_es
undines8716083undines
unfired112212453unfired
unfits93910293unfi_ts
unfixes17238113unfixes
unfolds11146803unfolds
unfurls1035573unfurls
ungirding1245153ungirding
unglues836993unglues
unguard955093unguard_
ungues7412123ung_ues
unguis738453ung_uis
unhairs1036373unhair_s
unhands1137773unhands
unhired112512153unhired
unhoods1137503unhoods
unions64216753un_ions
unipods1095703unipods
unitards945623unitards
unites65024853un_ites
units54923433un_i_ts
unkind113310573unkind_
unkinks10265413unkinks
unleads8228623unleads
unlinks11307403unlinks
unlives102010953unlives
unloads8278523unloads
unmitres1036863unmitres
unmixes16197753unmixes
unmolds10135743unmolds
unpicks1545183unpicks
unpiles92112783unpiles
unpins82312383unpi_ns
unrigs7159003unri_gs
unrips8199453unri_ps
untidy1059153unti_dy
untied73720813untied_
unties64326923unti_es
untired82316383untired
untrims938613untrims
unwind102610543unwind_
unwits9389893unwi_ts
unzips17175273unzi_ps
upbinds12234813upbinds
upgirded1342333upgirded
upgirt9117263upgir_t
upwards13135963upwards
upwinds13224223upwinds
urds55922423u___rds
urgers73313623urger_s
ursids737823ursi_ds
weirds10478053_weirds
yairds10448023_yairds
yirds96612513__yirds

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.1561145455.1
2DLD Change Limit1340271396.59320328.7
3Display Results1391390.0632206.3
 (SQL Overall)1786911396.81226231.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.