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

101 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
firearms133540(None) 
firearm1237201firearm_
forearms1336601forearms
firearmed1544042firearmed
firers94922682fire_r_s
fireworms1745602fireworms
forearm1238702forearm_
prearms11369172_prearms
rearms85114652__rearms
sidearms1144092sidearms
airers64922313aire_r_s
airfares1146693airfares
airparks1443913airparks
arrears738843arrear_s
birdfarms1741853birdfarms
breams104815043_brea_ms
creams104715253_crea_ms
dirams94413703dir_a_ms
dirhams13376313dirha_ms
disarms1039043di_sarms
dreams94513983_drea_ms
drears74614253_drear_s
farers95924053fare_r_s
farms106324953f___arms
fears84829393f__ear_s
ferbams1435743ferba_ms
fiars86720833fi__ar_s
fibers114717523fibe_r_s
fideisms1444453fideisms
fifers125414923fife_r_s
filers94623723file_r_s
finmarks17154473finmarks
fireable131710223fireable
firebacks2046303firebacks
fireballs14126493fireballs
firebases1446583firebases
firebirds1544023firebirds
fireboards1645433fireboards
firebomb1743413firebomb
firebombs1842863firebombs
firebrat1348143firebrat
firebrats1445883firebrats
firebugs14113823firebugs
firedamp1643743firedamp
firedamps1742843firedamps
firedogs1344793firedogs
firefangs1643053firefangs
fireguards1552383fireguards
firehalls15105173firehalls
fireless112810593fireless
firepans1347153firepans
firepots1346893firepots
firer811229253fire_r__
firerooms1445403firerooms
fires85740753fire___s
firestorms1543293firestorms
firetrap1344863firetrap
firetraps1444303firetraps
firewalls15125353firewalls
fireworks1946553fireworks
fireworm1646693fireworm_
firmans12238523firma_ns
firmers124711443firmer_s
firms105217423fi___rms
firmwares1743853firmwares
fivers124420923five_r_s
fixers165112983fixe_r_s
fleams115011943f_lea_ms
forams115115913for_a_ms
forbears1337073forbear_s
forearmed1544863forearmed
foreparts1445223foreparts
forewarns1585633forewarns
foreyards1645503foreyards
forwards1537043forwards
freaks134713063f_rea_ks
freers94717303f_reer_s
frenums1236203f_renums
freres94716173f_re_res
friars93812093f_riar_s
friers94718933frie_r_s
hirers94518063hire_r_s
inarms8410093_i_narms
overarms13258383overarms
prearm104512353_prearm_
prewarms15406733_prewarms
realms84913493__realms
reams75729623__rea_ms
rearm75923573__rearm_
rears54739653__rear_s
rewarms12439603__rewarms
screams114810623screa_ms
sidearm1035973sidearm_
sirdars8228213sirdar_s
streams94713373strea_ms
tonearms1044713tonearms
uprears9107493uprear_s
wirers94617893wire_r_s
wireworms1745033wireworms
yardarms14123333yardarms
zirams17438643zir_a_ms

Search took 9 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.406440125.6
2DLD Change Limit1461621017.65619091.2
3Display Results1011010.0462195.7
 (SQL Overall)1786911018.10822038.9
 
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.