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

98 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
firepans134715(None) 
firepan1236981firepan_
firefang1543922firefang
firefangs1643052firefangs
fireman1249332fireman_
firepink1753982firepink
firepinks1852822firepinks
firepots1346892firepots
firmans12238522fir_mans
fivepins1644082fivepins
forepaws1695752forepaws
frypans1544052f_rypans
trepans92311592_trepans
arepas85515703_arepa_s
crepons1139323_crepons
dishpans14115833dishpans
firearm1237203fire_arm
firearms1335403firearms
fireback1946953fireback
firebacks2046303firebacks
fireball13127263fireball
fireballs14126493fireballs
firebase1346493firebase
firebases1446583firebases
fireboats1446413fireboats
firebrand1544633firebrand
firebrands1643743firebrands
firebrats1445883firebrats
firebugs14113823firebugs
fireclays1743353fireclays
firedamp1643743firedamp
firedamps1742843firedamps
firedogs1344793firedogs
firehall14105613firehall
firehalls15105173firehalls
fireless112810593fireless
firemanic1653973firemanic
firemen1238773firemen_
fireplace1644873fireplace
fireplaces1744343fireplaces
fireplug1442083fireplug
fireplugs1542123fireplugs
firepot1248733firep_ot
firers94922683fire__rs
fires85740753fire___s
firetraps1444303firetraps
firewall14125933firewall
firewalls15125353firewalls
firkins1437663fir_kins
firman112211343fir_man_
firns86018543fir___ns
forebays1637263forebays
forehand1537693forehand
forehands1656743forehands
foreland1239013foreland
forelands1347173forelands
foreman12312363foreman_
forepart1349703forepart
foreparts1445223foreparts
forepast1348043forepast
forepaw1595613forepa_w
forepeaks18104573forepeaks
foreplays1745043foreplays
foreran10311793foreran_
forerank1546753forerank
foreranks1645293foreranks
foreruns1146623foreruns
forewarns1585633forewarns
freaks134713063f_re_aks
frypan1434543f_rypan_
furans94515953fur__ans
hardpans1436453hardpans
inspans937803_inspans
kneepans1462733kneepans
lifespans1462463lifespans
ninepins1045873ninepins
prepays1437483_prepays
preplans1249613_preplans
redans75421023__redans
remans84823003__remans
repand95316063__repand
repass84114703__repass
repays113813973__repays
repins84924313__repins
replans92814943__replans
sirenians944233sirenians
sirens65318153sire__ns
tarpans92513533tar_pans
tiepins939463ti_epins
trapans92812463_trapans
trepan82511673_trepan_
trepang10257293_trepang
trepangs11205403_trepangs
virelais1146413virelais
virelays1444643virelays
wireman1237843wireman_
wiretaps13144733wiretaps
wireways1745833wireways

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.436409841.7
2DLD Change Limit146162987.43619656.0
3Display Results98980.0462130.4
 (SQL Overall)178691987.91822567.7
 
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.