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

96 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
geese6431600(None) 
gees55647881gees_
geest64829611geest
bees65453382bees_
cease75227652cease
cees65941592cees_
cense75121402cense
cheese113812762cheese
creese84014332creese
dees56356632dees_
dense65923502dense
ease45042332_ease
egest65222342egest
else45923082_else
fease84824872fease
fees76450602fees_
feeze174913822feeze
fesse86116332fesse
gaes56348032gaes_
geds66730812geds_
gee45359202g_e_e
geed65435502gee_d
geek95327022gee_k
geeked124510162geeked
geeks104915842geeks
geeky134710732geeky
geests75912162geests
geez146424862gee_z
geezer16278012geezer
gelee63626982gelee
gelees74116262gelees
gels56836102gels_
gems75329112gems_
gene56237222g_ene
genes65133092genes_
geneses82613522geneses
genie66124922genie
genre66016802genre
gens55740072gens_
geode7412592geode
gesso649602gesso
gest56149132g_est
geste65920692geste
gets55442482gets_
geyser1036512geyser
ghee85726112ghe_e
ghees95215552ghees_
gies55641422gies_
glebe85016442glebe
glede75517832glede
glee55239062gle_e
glees65027592glees_
goes55644092goes_
goose65925902goose
gorse65926812gorse
grease75416232grease
grebe85114942grebe
gree56641562gre_e
grees65132472grees_
guess64213362guess
guest65225922guest
guise64717712guise
heeze175313482heeze
jees115938542jees_
jesse126012832jesse
keeve124512122keeve
lease55230262lease
lees45455882lees_
lense54523432lense
mense75025632mense
obese75212422obese
ogees65119142ogees_
pease75231112pease
pees65257372pees_
peeve104915252peeve
peise75825772peise
perse75429522perse
prese75228382prese
rees45364192rees_
reest54938092reest
reeve84121322reeve
resee54336332resee
reuse56025362reuse
sees45361052sees_
seise54727852seise
sense55526822sense
tease55428712tease
tees45353582tees_
tense55225842tense
terse55026822terse
these86519012these
vees75439432vees_
verse84723582verse
wees76249122wees_
weest85026772weest
zees136331892zees_

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.0931921408.6
2DLD Change Limit53800961.90628226.7
3Display Results96960.0303200.0
 (SQL Overall)178691962.02988068.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.