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

129 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
firefly163563(None) 
briefly1534572briefly
direly10311562dire_ly
fierily1339022fierily
finely123011562fine_ly
fireclay1644182fireclay
firmly1436662fir_mly
firstly1335642firstly
fixedly2133912fixedly
freely12310962f_reely
liefly1266362li_efly
refly113914562__refly
tiredly1136802tiredly
airily93014823air_ily
barely114716793bare_ly
barfly14339653bar_fly
chiefly1834103chiefly
cicely1338833cice_ly
deerfly1443983deerfly
directly1455303directly
direful1156613direful
direfully1644783direfully
dirtily1138583dirtily
fadedly1535453fadedly
fairly125610013fair__ly
farfel124310433farfel_
farfels13348213farfels
feebly1436653f_eebly
felly114922803f__elly
ferly115517353f__erly
feyly14429513f__eyly
fibrefill1751693fibrefill
fickly18318533fi_ckly
fiddly14328483fi_ddly
fief107331363fi_ef__
fiefs116213703fi_ef_s
field95015323fi_e_ld
fiercely1643313fiercely
fiery114714793fi_e_ry
fifthly1943093fifthly
fifty145211423fi__fty
figuredly1742313figuredly
filly114424903fi__lly
filmily1535733filmily
finally13310103finally
finery124512893fine_ry
fire76245593fire___
fireable131710223fireable
firearm1237203firearm
fireball13127263fireball
firebox1944453firebox
firebug1383793firebug
fireclays1743353fireclays
fired94829743fire__d
firedog1244473firedog
firefang1543923firefang
fireflies1545353fireflies
fireflood1642743fireflood
firehall14105613firehall
firelit10310863firelit
fireman1249333fireman
firemen1238773firemen
firepan1236983firepan
fireplug1442083fireplug
firepot1248733firepot
firer811229253fire__r
firers94922683fire_rs
fires85740753fire__s
firewall14125933firewall
firry115713533fir__ry
fishily1637643fishily
fitly115114973fi__tly
fivefold1852553fivefold
fleetly1336323fleetly
forcedly1744803forcedly
forebay1538133forebay
foreby1438633fore_by
forefelt14117363forefelt
foreplay1645673foreplay
forkedly1944323forkedly
formerly1645003formerly
freaky16439233f_reaky
freckly19124593f_reckly
frenzy2135883f_renzy
freshly16286833f_reshly
fretty1249223f_retty
friarly13316213friarly
friendly1544383friendly
frilly124111443f_rilly
frizzly21455793frizzly
furrily1337613furrily
girly94415293gir__ly
greyly13316543_greyly
horsefly1744873horsefly
ireful948713_ireful
irefully1445943_irefully
likely13328133like_ly
lively123310813live_ly
merely111312593mere_ly
mirkily16266403mirkily
miserly12329823miserly
misrely12319613misre_ly
mixedly2033983mixedly
nicely1139493nice_ly
overfly16246883overfly
purely114013633pure_ly
rarefy12296343raref_y
rarely93513653rare_ly
redly94217203__redly
refry114412463__refry
rely75428953__re_ly
reply104015853__reply
rifely123710033rife_ly
ripely112511153ripe_ly
sorely94618013sore_ly
surely93816463sure_ly
timely113410113time_ly
trebly1138973_trebly
vilely1239443vile_ly
virally1339653virally
virelay1335943virelay
vixenly2043193vixenly
whitefly2042513whitefly
widely133311033wide_ly
wifely15429423wife_ly
wireway1646043wireway
wirily123310783wir_ily
wisely122711713wise_ly
yarely122810303yare_ly

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 Limit1340271296.98319193.3
3Display Results1291290.0304300.0
 (SQL Overall)1786911297.41924085.6
 
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.