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

107 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
firepan123698(None) 
fireman1249331fireman
firepans1347151firepans
firefang1543922firefang
firemen1238772firemen
firepink1753982firepink
firepot1248732firepot
firman112211342fir_man
foreman12312362foreman
forepaw1595612forepaw
foreran10311792foreran
frypan1434542f_rypan
trepan82511672_trepan
wireman1237842wireman
airman82414223air_man
arepa75615563_arepa_
arepas85515703_arepas
birdman1236673birdman
crepon1039943_crepon
dishpan13105523dishpan
finespun1341883finespun
fire76245603fire___
firearm1237203firearm
fireback1946953fireback
fireball13127263fireball
firebase1346493firebase
fireboat1349093fireboat
firebox1944453firebox
firebrand1544633firebrand
firebrat1348143firebrat
firebug1383793firebug
fireclay1644183fireclay
fired94829743fire__d
firedamp1643743firedamp
firedog1244473firedog
firefangs1643053firefangs
firefly1635633firefly
firehall14105623firehall
firelit10310863firelit
firemanic1653973firemanic
firepinks1852833firepinks
fireplace1644873fireplace
fireplug1442083fireplug
firepots1346893firepots
firer811229253fire__r
firers94922683fire_rs
fires85740753fire__s
firetrap1344863firetrap
firewall14125933firewall
firkin1337823fir_kin
firmans12238523fir_mans
firn76927513fir___n
fivepins1644083fivepins
foeman11311233f_oeman
forebay1538133forebay
forehand1537693forehand
foreign1136833foreign
foreland1239013foreland
foremen12412923foremen
forepart1349703forepart
forepast1348043forepast
forepaws1695753forepaws
forepeak17134783forepeak
foreplay1645673foreplay
forerank1546753forerank
forerun1037653forerun
foresaw1377133foresaw
forewarn14117173forewarn
freak125115243f_re_ak
freeman1237343freeman
frena85915273f_rena_
frypans1544053f_rypans
furan84320013fur__an
hardpan1336443hardpan
iceman1037853_iceman
inspan837513_inspan
kirkman1243773kirkman
kneepan1372633kneepan
lifespan1382493lifespan
lineman939123lineman
ninepin945573ninepin
pikeman1535523pikeman
preman104117453_preman
prepay13310313_prepay
preplan1149953_preplan
redan66125013__redan
reman75730153__reman
repand95316063__repand
repay104818453__repay
repin75324703__repin
replan83215823__replan
reran57329103__reran
rewan85623663__rewan
sideman1037973sideman
sierran737193sierran
siren54525823sire__n
sirenian845783sirenian
tarpan82814293tar_pan
tiepin839343ti_epin
trapan82412973_trapan
trepang10257293_trepang
trepans92311593_trepans
virelai1045593virelai
virelay1335943virelay
wiremen1236903wiremen
wiretap12145723wiretap
wireway1646043wireway

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 Limit1340271076.90619407.3
3Display Results1071070.0303566.7
 (SQL Overall)1786911077.34224338.2
 
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.