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

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

96 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
girly9441529(None) 
gilly94321631gilly
girl56226551girl_
girls64518391girls
airily93014822airily
airy75734152air_y
bialy105119322bialy
bigly114814752bigly
billy105525362billy
birl65830472birl_
birle75023632birle
birls74023162birls
burly104922832burly
curly105321232curly
dilly94923782dilly
dimly114913482dimly
direly10311562direly
dirl57430022dirl_
dirls64720502dirls
dirty95617802dirty
drily95816522drily
early85324122early
fairly125610012fairly
ferly115517352ferly
filly114424902filly
firmly1436662firmly
firry115713532firry
fitly115114972fitly
gaily95020972gaily
gainly1049322gainly
gally95026172gally
gayly124513092gayly
germy115113662germy
giddy115810202giddy
giggly12518702giggly
gild65526512gi_ld
gill56336182gi_ll
gills64728192gills
gilt56348542gi_lt
gimpy135212232gimpy
ginny95314572ginny
gipsy11579542gipsy
gird65424992gir_d
girdle82110462girdle
girds74816992girds
girlie73711462girlie
girn56026862gir_n
girns64516802girns
giro55828632gir_o
giron66118992giron
giros65722652giros
girsh95310022girsh
girt56646422gir_t
girth95618842girth
girts65423622girts
glibly1236292glibly
gnarly104610382gnarly
godly104913292godly
golly95121102golly
gorily10612502gorily
gorsy95915782gorsy
gory86129662gor_y
gray85329892g_ray
grey85624042g_rey
grill64617892grill
grimly12459932grimly
grimy114312602grimy
gripy115115252gripy
grisly104310582grisly
gully94020682gully
gurry94515412gurry
hilly114422162hilly
hiply134113612hiply
hurly115819292hurly
idly85617322_idly
illy76925332_illy
inly75622212_inly
lily76730182li_ly
marly106925612marly
mirky146315522mirky
miry96326752mir_y
oily77932252oi_ly
pily96132732pi_ly
silly84527622silly
surly85124432surly
swirly12439252swirly
tirl45029922tirl_
tirls54519802tirls
twirly12427082twirly
virl76224472virl_
virls85618602virls
whirly15448862whirly
willy115321912willy
wily106428812wi_ly
wirily123310782wirily
wiry106422832wir_y

Search took 3 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 Filter178691538000.360496363.9
2DLD Change Limit53800961.73331044.4
3Display Results96960.0332909.1
 (SQL Overall)178691962.12684050.3
 
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.