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

122 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
furmety153481(None) 
furmenty1645291furmenty
furmity1535181furmity
ferrety13287012ferrety
frumenty1644572frumenty
fumet105630222fu_met_
fumets114311812fu_mets
surety93515012sur_ety
armet76739453_armet_
armets84918353_armets
buret77444013bur_et_
burets84321263bur_ets
burley114715753burle_y
burnet84326173burnet_
burnets93813263burnets
cermet10321153cermet_
cermets1139713cermets
curet75447643cur_et_
curets84922343cur_ets
curtesy1265833curtesy
curvet114720243curvet_
curvets12399913curvets
curvey144111843curve_y
dubiety1344583dubiety
farmed125117653farme_d
farmer115017373farme_r
farmers124315263farmers
ferity122813343fer_ity
fermata12278143fermata
fermate122813003fermate
ferment12315573ferment
ferments13311473ferments
fernery1335813fernery
ferret93021173ferret_
ferrets103111393ferrets
fidgety15384893fidgety
firmed125411883firme_d
firmer114712443firme_r
firmers124711443firmers
firmest1239273firmest
firmly1436663firm_ly
flummery1833053flummery
foreby1438633for_eby
forgery14419303forgery
forget106326393forget_
forgets113813793forgets
format113021353format_
formate123115093formate
formats123113573formats
forme105225993forme__
formed125021173forme_d
formee113919943forme_e
former114221403forme_r
formerly1645003formerly
formers128217953formers
formes114623713forme_s
forty114824273for__ty
freely12310953f_reely
fret75845043f_r_et_
frets85523403f_r_ets
fretty1249223f_retty
fromenty1645243fromenty
frosty124710633f_rosty
fruity12429693f_ruity
frumpy16466883frum_py
fullery13337973fullery
fume96727633fu_me__
fumed116118823fu_me_d
fumer105918233fu_me_r
fumers113613383fu_mers
fumes105224703fu_me_s
fumette1245523fu_mette
fumy127118583fu_m__y
furcate12310453furcate
furies95126373furie_s
furled104717053furle_d
furler93616403furle_r
furlers104214223furlers
furless103210143furless
furmeties1446573furmeties
furred104514433furre_d
furriery14395683furriery
furrily1337613furrily
furrowy16384473furrowy
furry116719283fur__ry
fury107727973fur___y
furze176815813furze__
furzes186613693furze_s
furzy2010116063fur__zy
fusty115016513fu__sty
gargety12388043gargety
gourmet1059203gourmet_
gourmets1144153gourmets
gurnet74920873gurnet_
gurnets84010793gurnets
gurney10429413gurne_y
hurley125012523hurle_y
mummery13336663mummery
murrey114312263murre_y
nuggety1234313nuggety
nursery10396023nursery
purely114013623pur_ely
purity114114913pur_ity
purty105019403pur__ty
purvey14559573purve_y
russety1034613russety
suety85318493su__ety
summery14329413summery
surely93816463sur_ely
surgery11319213surgery
surrey94414583surre_y
survey124111673surve_y
tumefy1434223tu_mefy
turbeth1274713turbeth
turkey1337763turke_y
turnery10357423turnery
turpeth1284813turpeth
turret63121853turret_
turrets73010673turrets
ubiety1135913_ubiety
unmet74426393_unmet_
variety1337743variety

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 Filter1786911340270.1731032896.0
2DLD Change Limit1340271227.20318607.1
3Display Results1221220.0304066.7
 (SQL Overall)1786911227.40624127.9
 
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.