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

107 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
guises7421631(None) 
guides84118281guides
guiles73919281guiles
guise64717711guise_
guised84612171guised
anises64826692anises
arises65233802arises
axises134413992axises
bises75435622_bises
brises84927612brises
bruises93212912bruises
burses84425512burses
buses75936012bu_ses
busies85525262busies
busses85023382busses
crises84529432crises
cruises93514442cruises
cuishes122810822cuishes
cuisse8318332cuisse
cuisses9319882cuisses
curses85328272curses
cusses84522772cusses
cutises94414912cutises
daises74318982daises
dulses73913652dulses
egises7312492egises
frises94124272frises
fuses85628422fu_ses
fusses94920552fusses
gases65633992g_ases
gasses75724782gasses
gausses8308692gausses
gibes84422522g_ibes
gies55641422g_i_es
gists66026192g_ists
gites65630182g_ites
gives95324872g_ives
glides84518862glides
glimes94717522glimes
gnoses76515162gnoses
gooses75723052gooses
gorses74723292gorses
grides84422362grides
grilses8319152grilses
grimes94619032grimes
gripes94619872gripes
grists74716482grists
gudes74520812gu_des
guess64213362gues_s
guesses8169372guesses
guests74311202guests
guide75019882guide_
guided94014112guided
guider84313522guider
guiders94111112guiders
guids75516152gui_ds
guilds8388352guilds
guile64521132guile_
guiled84315382guiled
guilts74111232guilts
guimpes1245072guimpes
guinea737612guinea
guineas836752guineas
guiros7389092guiros
gules64831042gu_les
gunites8313122gunites
gunsel7339852gunsel
gunsels8338132gunsels
gurges84716862gurges
gurshes112210032gurshes
gushes104719032gushes
gusset7316432gusset
gussets837442gussets
gussies82813302gussies
gusts65722792gu_sts
hoises94823672hoises
ibises83610542ibises
irises64221172irises
juices1549422juices
krises105016082krises
mises74740562_mises
muses75134302mu_ses
musses84624782musses
noises65021852noises
nurses63919352nurses
peises84125042peises
poises84226542poises
prises84133172prises
puisnes937422puisnes
pulses83818662pulses
purses84826372purses
puses75532202pu_ses
pusses84322842pusses
quires154015742quires
raises64826542raises
rises55244042_rises
ruses56136582ru_ses
seises64026712seises
sises55233832_sises
sudses74114502sudses
suites63727402suites
susses64221052susses
tusses64921242tusses
uses44931112_u_ses
vises84427772_vises
wises85633192_wises
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 Limit825511072.20337472.1
3Display Results1071070.0303566.7
 (SQL Overall)1786911072.34376265.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.