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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
furriners1231632(None) 
furriers11369491furri_ers
furriner11267301furriner_
furriness12287601furriness
curriers103410752curri_ers
farriers113610742farri_ers
furrier103513662furri_er_
furriery14395682furri_ery
furrings12317142furrin_gs
furrowers1563502furrowers
hurriers11358892hurri_ers
airliners945983airliners
arrivers11137003_arrivers
barriers104311883barri_ers
blurriness1243483blurriness
briners94315633__briners
burdeners1245063burdeners
buriers94017193bu_ri_ers
burliness1137833burliness
burners94115673bu_r_ners
burrers93814493burr__ers
burrier93613553burri_er_
burrowers1483493burrowers
carriers103614203carri_ers
curarines11710553curarine_s
curliness1138553curliness
currier93316703curri_er_
curriery13326163curri_ery
curries93723163curri_e_s
derringers1243843derringers
drainers92811253_drainers
durries83817353durri_e_s
farrier103514893farri_er_
farriery14295403farri_ery
ferreters1246253ferreters
ferries103521083ferri_e_s
ferrites112312833ferrite_s
fieriness1238623fieriness
firrier103410133firri_er_
fluorines1247553fluorine_s
flurries11188913flurri_e_s
foreigners1444143foreigners
forgivers1643713forgivers
forkiness16268703forkiness
fourdriniers1671153fourdriniers
friers94718933f__ri_ers
frizers19329553f__rizers
frowners14377933f_rowners
fruiters11328183f_ruiters
fuhrers1334813fuhr__ers
fulmines1357783fulmine_s
funkiness16226873funkiness
funniness12256533funniness
furanes103214863fu_rane_s
furbishers1843093furbishers
furies95126373fu_ri_e_s
furlers104214223fu_r_lers
furnishers1643633furnishers
furrieries1343943furri_eries
furriest112910793furri_est
furrinesses1437183furrinesses
furring114013143furrin__g
furrower1464033furrower_
furthers1436493fu_rthers
furzier19318103furzi_er_
fussiness12226583fussiness
fustiness121910243fustiness
fuzziness2033173fuzziness
grainers93012073_grainers
gurries83515953gurri_e_s
harriers113712433harri_ers
hurrier103412943hurri_er_
hurries103919653hurri_e_s
loriners839963_loriners
mariners103113863_mariners
marriers103312473marri_ers
merriness1138293merriness
murines93718223mu_rine_s
murkiness15206293murkiness
murries94118673murri_e_s
murrine9411483murrine__
outliners9228363outliners
outriders10237223outriders
parriers103612903parri_ers
porringers1343743porringers
purines94420763pu_rine_s
purlines103514053purline_s
purloiners1242813purloiners
pursiness1138453pursiness
quarriers1845183quarri_ers
queriers1736963queri_ers
ruiners74213023__ruiners
sorriness939583sorriness
spurriers11245063spurri_ers
strainers9510383strainers
surliness939943surliness
surmisers1145203surmisers
surprisers1243633surprisers
surrenders1174153surrenders
survivers1543883survivers
tarriers83411713tarri_ers
tarriness9229243tarriness
terriers84210823terri_ers
terrines82117553terrine_s
trainers83114643_trainers
turbines1039903turbine_s
turners73912893tu_r_ners
uprisers10206773_uprisers
uprivers13215563_uprivers
urines64724123_u_rine_s
warreners1236193warreners
worriers11257813worri_ers

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411127.18620684.8
3Display Results1121120.0631777.8
 (SQL Overall)1786911127.67223291.3
 
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.