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 “upgirds” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
upgirds1110307(None) 
ungirds9105301ungirds
upgird10103931upgird_
begirds1134882begirds
engirds995052engirds
girds74817002__girds
ungird887972ungird_
upbinds12234812upbinds
upgirded1342332upgirded
upgirt9117262upgir_t
upwards13135962upwards
upwinds13224222upwinds
aphids125110843aphi_ds
begird1036823begird_
birds85421343__birds
busgirls1142653busgirls
cairds96411513_cairds
cupids11369193cup_i_ds
engilds974863engilds
engird8126973engird_
gids65933753__gi_ds
gilds75417533__gilds
gird65425003__gird_
girls64518393__girls
girns64516803__girns
giros65722653__giros
girts65423623__girts
grids75321403__grids
hegiras1136103hegiras
lairds74711613_lairds
pairs75325833_pair_s
pards85634333_p_ards
pirns76020093_p_irns
poinds93511143_poinds
regards94112563regards
regilds996673regilds
shairds11216263shairds
sparids103512123sparids
speirs85013233speir_s
spires84628113sp_ires
spirts85317133sp_irts
sunbirds1143903sunbirds
thirds10438603_thirds
umpires1137813umpires
unbinds10267353unbinds
ungirded1136083ungirded
ungirt71112713ungir_t
unguards1053993unguards
unwinds11286733unwinds
upbind11246313upbind_
upbuilds1341753upbuilds
upcurls1143653upcurls
updarts1034203updarts
updives1334713updives
updries10209083updries
upends9438763up_ends
upfolds13133753upfolds
upgazes1933573upgazes
upgirding1442373upgirding
upgrade11215823upgrade
upgrades12216063upgrades
upgrew1233653upg_rew
upgrow1234273upg_row
upgrows1334323upgrows
uphills1295233uphills
uphoards1443763uphoards
upholds13135243upholds
uplands1036943uplands
uplifts12424773uplifts
uplinks13345613uplinks
uploads10266503uploads
uppers102912293upper_s
uppiles11208263uppiles
uppings12257123uppings
uprises92012733uprises
upsends10265293upsends
upside9289803upsi_de
upsides10319633upsides
upsizes18297163upsizes
upstirs935293upstir_s
upticks1535153upticks
uptilts934733uptilts
uptimes1177553uptimes
upturns9264973upturns
upward12147163upward_
upwind12255823upwind_
urds55922443u___rds
urgers73313623urger_s
ursids737823ursi_ds
weirds10478053_weirds
yairds10448023_yairds
yirds96612523__yirds

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 Limit134027926.64020184.8
3Display Results92920.0303066.7
 (SQL Overall)178691927.07625253.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.