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 “furans” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
furans9451595(None) 
burans85019301burans
furan84320011furan_
furane94015491furane
furanes103214861furanes
anurans73810552anurans
auras55932562aura_s
brans75437432_brans
buran75225302buran_
buras74736302bura_s
burins84221892burins
burns74926782bur_ns
curns74924282cur_ns
currans9310612currans
duras65727732dura_s
durians839572durians
durns64819872dur_ns
fans76247372f__ans
farads104713272farads
ferals94216642ferals
ferns85220082fer_ns
firmans12238522firmans
firns86018542fir_ns
flans85327972f_lans
forams115115912forams
forays124813002forays
frags96322172f_rags
franc104615412f_ranc
francs114112192f_rancs
frank124417512f_rank
franks134912732f_ranks
fraps105620552f_raps
frass85321122f_rass
frats86829672f_rats
frays116920102f_rays
frons86124042f_rons
funs75235732fu__ns
furanose1144752furanose
furies95126372furies
furls85322052fur_ls
furors9310952furors
furs76735042fur__s
furzes186613692furzes
fusains1038362fusains
futons93911512futons
grans64832542_grans
guans64419442gu_ans
humans112312432humans
jurant134216552jurant
jurants14379212jurants
jurats134213202jurats
kurgans12145652kurgans
lorans65117602lorans
lurdans837072lurdans
murals84016762murals
muras75329582mura_s
ourang73311062ourang
ourangs8318502ourangs
purana8712932purana
puranas9712642puranas
purins83722652purins
pyrans11411062pyrans
queans153110752queans
sarans64224432sarans
surahs94515542surahs
suras55336332sura_s
trans54933042_trans
turbans939562turbans
turns55623242tur_ns
ulans54921302_ulans
urns46323902_ur_ns
yuans84613322yu_ans
yulans958672yulans

Search took 5 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 Filter178691825510.406440125.6
2DLD Change Limit82551733.89021221.3
3Display Results73730.0461587.0
 (SQL Overall)178691734.34241154.1
 
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.