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

55 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
fervours145305(None) 
fervors1336231fervo_rs
fervour1343101fervour_
devours1166642de_vours
favours13437092f_avours
ferrous1049792ferrou_s
fervor1235642fervo_r_
flavours1434692flavours
nervous1037142nervou_s
arbours93910043_arbours
ardours8368883_ardours
armours9389853_armours
bescours1245093bescours
bevors111610343be_vo_rs
cerous85821203cer_ou_s
detours858043de_tours
devoirs1175783de_voirs
devour1076703de_vour_
dyvours1453183_dyvours
errors63311313_erro_rs
faitours1134263faitours
farceurs13464723farceurs
favors124211403f_avo_rs
favour12438333f_avour_
femurs1136713fe__murs
fermiums1544353fermiums
ferreous1146033ferreou_s
ferrums1265983fer_rums
fetors91014473fe_to_rs
fevers125414893fe_v_ers
flavors1337293flavo_rs
flavour1334633flavour_
flavoury1743063flavoury
flours94414053f__lours
forgoers1236413forgoers
fours85521493f___ours
fulvous1334543fulvou_s
furious103110633furiou_s
furors9310953fur_o_rs
harbours1346923harbours
nervure1034973nerv_ure
nervures1135123nerv_ures
parlours1036153parlours
pervious1337543perviou_s
repours9310233re_pours
savours10389343_savours
serious73616283seriou_s
serous65023563ser_ou_s
serovars1145233serovars
servers103214833serv_ers
servos93812723servo__s
tenours72610073te_nours
termors94712773termo_rs
terrors73112213terro_rs
velours10278083ve_lours

Search took 9 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.533335255.2
2DLD Change Limit146162557.72018932.9
3Display Results55550.0301833.3
 (SQL Overall)178691558.28321573.2
 
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.