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

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

178 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
furls8532205(None) 
burls74228851burls
curls74927101curls
farls85731111farls
fuels87117351fuels
fulls84623521fulls
furl77030881furl_
furs76735041fur_s
hurls86522711hurls
nurls55519681nurls
purls74723351purls
auras55932562auras
aures55137092aures
auris55331532auris
birls74023162birls
buhls105111802buhls
bulls75629572bulls
buras74736302buras
burbs95423492burbs
burds84626062burds
burgs84924092burgs
burl64937182burl_
burly104922832burly
burns74926782burns
burps94220172burps
burrs74925652burrs
burs65847422bur_s
byrls105711232byrls
carls77037422carls
churls115411072churls
culls75425812culls
curbs94821652curbs
curds85725612curds
cures75645432cures
curfs105122142curfs
curl66035052curl_
curly105321232curly
curns74924282curns
currs75624392currs
curs65645542cur_s
dirls64720502dirls
duals65620082duals
duels65619232duels
dulls64523742dulls
duras65727732duras
dures65635922dures
durns64819872durns
duros65422692duros
durrs65519992durrs
earls56127512earls
euros54920242euros
fails85631482fails
falls85727652falls
fards96629842fards
fares85852872fares
farl76338552farl_
farle86929242farle
farles96025782farles
farms106324952farms
faros85532022faros
farts88336842farts
feels85223042feels
fells85327382fells
ferals94216642ferals
feres86038182feres
ferly115517352ferly
ferns85220082ferns
fills84632372fills
fils75838692f_ils
fires85740752fires
firms105217422firms
firns86018542firns
firs76637712fir_s
foals85721692foals
foils85025812foils
fools86824202fools
forbs105720802forbs
fords95328182fords
fores85847102fores
forks125324682forks
forms105327052forms
forts86034452forts
fouls87221432fouls
fours85521492four_s
fowls115518892fowls
frugs96114282frugs
fubs96328792fu_bs
fucks144419252fucks
fucus105515892fucus
fuds86528562fu_ds
fuel76824732fuel_
fugle94915542fugle
fugles104715782fugles
fugs85730692fu_gs
fugus95914012fugus
fujis15379242fujis
full75229152fu_ll
fully114820862fully
fumes105224702fumes
funds94119252funds
funks125318912funks
funs75235732fu_ns
fur66637322fur__
furan84320012furan
furans94515952furans
furies95126372furies
furled104717052furled
furler93616402furler
furlers104214222furlers
furless103210142furless
furor8312392furor
furors9310952furors
furry116719282furry
fury107727972fur_y
furze176815812furze
furzes186613692furzes
furzy2010116062furzy
fusels94412452fusels
fuses85628422fuses
fusils93912342fusils
fuss76027932fu_ss
fuzes175120222fuzes
fuzils18407962fuzils
girls64518392girls
gulls65222982gulls
guls55930852gu_ls
gurus64318192gurus
harls85634502harls
herls85226432herls
hulls84923562hulls
hurds95219072hurds
hurl76029932hurl_
hurly115819292hurly
hurts86922822hurts
jarls126120962jarls
jurels133710582jurels
knurls10396242knurls
kurus98015632kurus
lulls54119652lulls
lures56138532lures
lurks95218742lurks
marls75535162marls
merls77423902merls
mulls75124152mulls
murals84016762murals
muras75329582muras
mures75937222mures
murks114821732murks
murrs75521302murrs
nulls55019982nulls
nurds65518522nurds
nurl45327242nurl_
ours47237562our_s
pulls74425052pulls
puls65437562pu_ls
puris75332022puris
purl65631422purl_
purrs75320432purrs
purs65641042pur_s
suras55336332suras
surds65624662surds
surfs85022542surfs
surly85124432surly
thurls9418712thurls
tirls54519802tirls
turds65021692turds
turfs84620442turfs
turks95320822turks
turns55623242turns
turps74918732turps
unfurls1035572unfurls
urbs65922062_urbs
urds55922432_urds
urns46323902_urns
urps66920482_urps
urus46426142_urus
virls85618602virls
yurts87216532yurts

Search took 3 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 Filter178691538000.310576422.6
2DLD Change Limit538001781.67332157.8
3Display Results1781780.0463869.6
 (SQL Overall)1786911782.02988068.5
 
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.