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

84 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
fireworm164669(None) 
firework1847411firework
fireworms1745601fireworms
wireworm1645891wireworm
firearm1237202fire_arm
fireroom1346062fireroom
firestorm1444562firestorm
firewood1546302firewood
fireworks1946552fireworks
fishworm1943802fishworm
foreword15118962foreword
foreworn14108862foreworn
wirework1846572wirework
wireworms1745032wireworms
beworm1339993__beworm
careworn1347883careworn
caseworm1546163caseworm
deworm1249533__deworm
earworm1238743ear_worm
farmwork2044193farmwork
feretory1447513feretory
figwort1448223fi_gwort
filiform1644773filiform
firearms1335403fire_arms
firebird1444633firebird
fireboard1546613fireboard
fireboat1349093fireboat
firebomb1743413firebomb
firebox1944453firebo_x
firedog1244473firedo_g
firedogs1344793firedogs
firelock1744823firelock
firepot1248733firepo_t
firepots1346893firepots
firer811229253fire__r_
firerooms1445403firerooms
firers94922683fire__rs
firestorms1543293firestorms
firethorn1543733firethorn
firewall14125933firewall
fireweed1545353fireweed
firewoods1645963firewoods
firmware1643963firmware
fishworms2043253fishworms
flatworm1645183flatworm
forearm1238703fore_arm
foreboom1546133foreboom
foredoom1445813foredoom
foreswore15117403foreswore
foresworn15126073foresworn
forewarn14117173forewarn
forewords16117403forewords
formwork2044533formwork
forswore14106963forswore
forsworn14125763forsworn
forworn13107793for_worn
freeform1644703freeform
fretwork1845693f_retwork
gapeworm1644003gapeworm
hairworm1644543hair_worm
hornworm1645253hornworm
lifework1844763lifework
mitrewort1465293mitrewort
pilewort1389133pilewort
pinworm1467183pi_nworm
piriform1555753piriform
preform1439613_preform
prewarm14479613_prewarm
prework164210913_prework
preworn124711223_preworn
reform11312713__reform
rewarm115913493__rewarm
reword106321413__reword
rewore938030163__rewore
rework136619793__rework
reworn98122203__reworn
ringworm1444673ringworm
screwworm1971883screwworm
silkworm1743583silkworm
tapeworm1545103tapeworm
timework1744803timework
timeworn1344233timeworn
tubeworm1544213tubeworm
wireworks1946023wireworks

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.423422437.4
2DLD Change Limit146162847.25020160.3
3Display Results84840.0302800.0
 (SQL Overall)178691847.70323197.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.