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

141 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
firearm123720(None) 
firearms1335401firearms
forearm1238701forearm
firearmed1544042firearmed
firer811229252fire_r_
firers94922682fire_rs
fireworm1646692fireworm
forearms1336602forearms
prearm104512352_prearm
rearm75923572__rearm
sidearm1035972sidearm
airer54927893aire_r_
airers64922313aire_rs
airfare1047243airfare
airpark1344923airpark
airward1148133airward
arrear6310253arrear_
arrears738853arrears
birdfarm1642873birdfarm
bream95121813_brea_m
cream95721353_crea_m
diram84419473dir_a_m
direr64927073dire_r_
dirham12378273dirha_m
disarm9310473di_sarm
dream85120393_drea_m
drear65016903_drear_
drears74614253_drears
dreary104611673_dreary
fairer95212063faire_r_
farer86733143fare_r_
farers95924053fare_rs
farm95934543f___arm
fear75337793f__ear_
fears84829393f__ears
ferbam1339003ferba_m
fiar76427343fi__ar_
fiars86720833fi__ars
fiber104921133fibe_r_
fibers114717523fibe_rs
fideism1335773fideism
fiery114714793fi_e_ry
fifer115519973fife_r_
fifers125414923fife_rs
filar84819293fi_lar_
filer85433003file_r_
filers94623723file_rs
finer85431563fine_r_
finery124512893fine_ry
finmark16154883finmark
fire76245603fire___
fireable131710223fireable
fireback1946953fireback
fireball13127263fireball
firebase1346493firebase
firebird1444633firebird
fireboard1546613fireboard
firebomb1743413firebomb
firebox1944453firebox
firebrat1348143firebrat
firebug1383793firebug
fired94829743fire__d
firedamp1643743firedamp
firedog1244473firedog
firefang1543923firefang
firefly1635633firefly
fireguard1442903fireguard
firehall14105623firehall
firelit10310863firelit
fireman1249333fireman
firemen1238773firemen
firepan1236983firepan
firepans1347153firepans
firepot1248733firepot
fireroom1346063fireroom
fires85740753fire__s
firestorm1444563firestorm
firetrap1344863firetrap
firewall14125933firewall
firework1847413firework
fireworms1745603fireworms
firm96026463fi___rm
firman112211353firma_n
firmans12238523firmans
firmer114712443firmer_
firmers124711443firmers
firmware1643963firmware
firry115713533fir__ry
fiver116024943five_r_
fivers124420923five_rs
fixer154717833fixe_r_
fixers165112983fixe_rs
fleam106017283f_lea_m
foram105124933for_a_m
forbare122310513forbare
forbear1237523forbear_
forbears1337073forbears
forearmed1544863forearmed
forepart1349703forepart
foreran10311793foreran
forewarn14117173forewarn
foreyard1546423foreyard
forward1438293forward
freak125115243f_rea_k
freaks134713063f_reaks
freaky16439233f_reaky
freer86021243f_reer_
freers94717303f_reers
frenum1188803f_renum
frere85617723f_re_re
friar85414273f_riar_
friars93812093f_riars
friary124010093f_riary
frier85225843frie_r_
friers94718933frie_rs
hirer85423123hire_r_
hirers94518063hire_rs
inarm7314423_i_narm
linear65113343linear_
overarm12239793overarm
prearms11369173_prearms
prewarm14479613_prewarm
realm75621623__realm
ream65841613__rea_m
rear45644553__rear_
rearms85114653__rearms
rears54739653__rears
rewarm115913493__rewarm
scream104814253screa_m
sidearms1144093sidearms
sirdar7269103sirdar_
sirdars8228213sirdars
stream84717293strea_m
tonearm937443tonearm
uprear8168793uprear_
uprears9107493uprears
wirer85124953wire_r_
wirers94617893wire_rs
wireworm1645893wireworm
yardarm13114533yardarm
ziram163912893zir_a_m

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 Limit1340271417.40618097.1
3Display Results1411410.0463065.2
 (SQL Overall)1786911417.85822740.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.