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

81 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
furnaced144351(None) 
furnace1235941furnace_
furnaces1336051furnaces
furcated1437592furcated
surfaced1436062surfaced
surnamed1135112surnamed
aurated83817793aur_ated
barnacled1444003barnacled
braced115420603_br_aced
burned95818963burn__ed
corniced1368593corniced
curated104717583cur_ated
durance1059113durance_
durances1158683durances
durned84113173durn__ed
faced117727653f___aced
farced125216533far__ced
fenced124412713f_en_ced
financed1435113f_inanced
foraged124812283for_aged
forayed14368593for_ayed
forced126316523for__ced
forenamed1545163forenamed
fornices1369103fornices
fracted1339373f_r_acted
framed125116523f_r_amed
franked153610053f_ranked
frayed135012163f_r_ayed
freaked15399703f_reaked
funded114413893fu_n_ded
funked144214113fu_n_ked
funned103613953fu_n_ned
funneled1254873funneled
furane94015493fur_ane_
furanes103214863fur_anes
furcate12310453furcate_
furcates1339883furcates
furled104717053fur__led
furnacing1543713furnacing
furnished1644583furnished
furred104514433fur__red
furrowed1563833furrowed
graced105217903_gr_aced
gurnard944773gurna_rd
hurrahed1543463hurrahed
hurrayed1543043hurrayed
journaled1742673journaled
lunated8310823lu_nated
menaced122710093_menaced
muraled10410833mur_aled
muriated1139793muriated
nuanced1036203nuan_ced
outfaced14219463outfaced
outpaced13269793outpaced
outraced112414203outraced
pranced123714043_pranced
raced87635313__r_aced
ruinated939523ruinated
surbased1136613surbased
surface1238653surface_
surfacer1345663surfacer
surfaces1338673surfaces
surname937603surname_
surnamer1044883surnamer
surnames1037273surnames
surtaxed1644133surtaxed
terraced11318123terraced
traced94821583_tr_aced
tranced104414173_tranced
turbaned1145623turbaned
turned73914473turn__ed
unacted10312733_u_nacted
unaged83916423_u_naged
unawed103914903_u_nawed
unaxed144113093_u_naxed
unlaced102913733_unlaced
unnamed102410273_unnamed
unraked122914013_unraked
unrated82621553_unrated
unrazed172511453_unrazed
urinated9311613_urinated

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 Limit146162817.51619446.8
3Display Results81810.0302700.0
 (SQL Overall)178691817.70223200.6
 
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.