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

64 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
fireside124700(None) 
firesides1346601firesides
foreside12310301foreside
farside1138602far_side
foresides1339702foresides
preside10715612_preside
reside74224932__reside
beside95114613__beside
curbside1344673curbside
diopside1245643diopside
farsides1237993far_sides
fiberize2246143fiberize
filicide1446363filicide
finesse10187643fines_se
finessed12136793finessed
fireable131710223fireable
firebase1346493firebase
firebird1444633firebird
firebirds1544023firebirds
fired94829743fire__d_
firelit10310863fireli_t
firepink1753983firepink
fires85740753fires___
fireship1646233fireship
fireships1746023fireships
firestone1247423firestone
fireweed1545353fireweed
fissile10269653fi_ssile
forebode1448273forebode
foredid1238503foredid_
foresaid1247803foresaid_
foresee10414333fores_ee
forested12312463forested
foretime1348213foretime
freshed143312593f_reshed
hillside1254673hillside
inside7613453_i_nside
ironside945853_ironside
kingside1444263kingside
lakeside1344673lakeside
oreide7311673_ore_ide
overside122013933overside
portside1138163portside
presided12410553_presided
presider11410423_presider
presides11414913_presides
resid64124093__resid_
resided95217703__resided
resider84615803__resider
resides84523283__resides
resids74219153__resids
residue8689863__residue
resile64627673__resile
resite64128453__resite
resize154117723__resize
ringside1045403ringside
riverside1344913riverside
shoreside1344733shoreside
surfside1244853surfside
tiresome1046993tiresome
ureide7310363_ure_ide
viricide1446423viricide
virucide1443593virucide
wirelike15167493wirelike

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.1561145455.1
2DLD Change Limit146162647.45319611.2
3Display Results64640.0461391.3
 (SQL Overall)178691647.65523343.0
 
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.