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

72 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
fusees9541640(None) 
fusee86224581fusee_
fusels94412451fusels
fuses85628421fus_es
fusses94920551fusses
fuzees184910751fuzees
buses75936012bus_es
bushes115226112bushes
busies85525262busies
busses85023382busses
cusecs10509152cusecs
cusses84522772cusses
cuvees1139372cuvees
fasces114914542fasces
fashes124524022fashes
fees76450602f__ees
fesses94820252fesses
fishes125221342fishes
flees85828752f_lees
flushes134114142flushes
fosses96022082fosses
frees86131392f_rees
frisees104411692frisees
fudges114314492fudges
fuels87117352fu_els
fugles104715782fugles
fugues104511682fugues
fumers113613382fumers
fumes105224702fu_mes
fumets114311812fumets
furies95126372furies
furzes186613692furzes
fuse76429992fus_e_
fused94820442fus_ed
fusel85218492fus_el
fuseless11237232fuseless
fusils93912342fusils
fuss76027932fus__s
fussed104613802fussed
fusser94813772fusser
fussers104210812fussers
futzes184313112futzes
fuzee175718882fuzee_
fuzes175120222fu_zes
fuzzes175412252fuzzes
gushes104719032gushes
hushes124718592hushes
lushes94022742lushes
musers84719092musers
muses75134302mus_es
mushes114124562mushes
musses84624782musses
mustees94614922mustees
ousels64815272ousels
outsees72616432outsees
purees84721682purees
puses75532202pus_es
pushes114621662pushes
pusses84322842pusses
resees63827482resees
rupees8312572rupees
ruses56136582rus_es
rushees103311952rushees
rushes94724362rushes
sees45361052__sees
susses64221052susses
tushes94319472tushes
tusses64921242tusses
tutees6514552tutees
users55817572_users
uses44931112_us_es
wusses93314892wusses

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 Filter178691825510.1101624463.6
2DLD Change Limit82551722.79629524.7
3Display Results72720.0135538.5
 (SQL Overall)178691722.91961216.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.