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

90 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
firework184741(None) 
fireworks1946551fireworks
fireworm1646691fireworm
wirework1846571wirework
farmwork2044192farmwork
firelock1744822firelock
firewood1546302firewood
fireworms1745602fireworms
foreword15118962foreword
foreworn14108862foreworn
formwork2044532formwork
fretwork1845692f_retwork
lifework1844762lifework
prework164210912_prework
rework136619792__rework
timework1744802timework
wireworks1946022wireworks
wireworm1645892wireworm
artwork1447093_artwork
capework1945803capework
careworn1347883careworn
casework1746773casework
cribwork1943523cribwork
falsework1943263falsework
farmworks2143843farmworks
feretory1447513feretory
fieldwork2062213fieldwork
figwort1448223fi_gwort
firearm1237203fire_arm
fireback1946953fireback
firebird1444633firebird
fireboard1546613fireboard
fireboat1349093fireboat
firebomb1743413firebomb
firebox1944453firebo_x
firedog1244473firedo_g
firedogs1344793firedogs
firelocks1844233firelocks
firepink1753983firepink
firepot1248733firepo_t
firepots1346893firepots
firer811229253fire__r_
fireroom1346063fireroom
firers94922683fire__rs
firestorm1444563firestorm
firethorn1543733firethorn
firewall14125933firewall
fireweed1545353fireweed
firewoods1645963firewoods
firmware1643963firmware
fishworm1943803fishworm
flatwork1845393flatwork
footwork1845813footwork
forelock1745593forelock
foreswore15117403foreswore
foresworn15126073foresworn
forewarn14117173forewarn
forewords16117403forewords
formworks2144133formworks
forswore14106963forswore
forsworn14125763forsworn
forworn13107793for_worn
framework2143403framework
fretworks1945113f_retworks
hairwork1845073hair_work
homework2045833homework
ironwork15125063_ironwork
lacework1746853lacework
lifeworks1944433lifeworks
linkwork1444253linkwork
millwork1745523millwork
mitrewort1465293mitrewort
overwork18118233overwork
piecework2043203piecework
pilewort1389133pilewort
pinwork16107243pi_nwork
preworks17599013_preworks
preworn124711223_preworn
recork126315493__recork
reword106321413__reword
rewore938030163__rewore
reworks145113603__reworks
reworn98122203__reworn
timeworks1844753timeworks
timeworn1344233timeworn
tinwork1476993ti_nwork
tubework1744743tubework
warwork1757583war_work
wireworms1745033wireworms
yardwork1944513yardwork

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 Filter1786911461620.420425454.8
2DLD Change Limit146162907.47019566.5
3Display Results90900.0461956.5
 (SQL Overall)178691907.93622516.5
 
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.