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

76 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
gullies8471731(None) 
bullies94121891bullies
cullies94419961cullies
gallies84122711gallies
gillies84120961gillies
gullied93812061gullied
sullies74122221sullies
allies63827672_allies
ballies93725742ballies
bellies94023722bellies
billies93923502billies
bullied104514812bullied
bullier94116432bullier
bulliest104314492bulliest
collies94326582collies
cullied104012352cullied
cullis84115992culli_s
cullises103111312cullises
dallies84023192dallies
dellies83622212dellies
dillies84122162dillies
dollies83620982dollies
fellies104119742fellies
fillies103420252fillies
follies103618942follies
gallied94114992gallied
ghillies12408662ghillies
gillie74816942gillie_
gillied95512312gillied
girlies83013702girlies
goalies8316022goalies
guiles73919282guil_es
gulches13398102gulches
gules64831042gu_l_es
gulfier1137792gulfier
gulfiest1247942gulfiest
gulled84521372gull_ed
gullet74924832gull_et
gullets84013712gullets
gulley104213162gull_ey
gulleys11438522gulleys
gulling94019562gulling
gulls65222982gull__s
gulpier1046952gulpier
gulpiest1137352gulpiest
gumlines11238572gumlines
gunnies83413122gunnies
guppies123310522guppies
gurries83515952gurries
gussies82813302gussies
guylines12236942guylines
hollies103420812hollies
hulloes104113922hulloes
hurlies103315332hurlies
jellies143816532jellies
jollies143516272jollies
kellies113516852kellies
killies113318112killies
lollies73116922lollies
mollies93420232mollies
muhlies1238932muhlies
mullites10411642mullites
nellies73418722nellies
outlies72421992outlies
rallies73823342rallies
sallies73227812sallies
sillies73425072sillies
sulkies114315762sulkies
sullied83714482sullied
tallies73624602tallies
tellies73820502tellies
tulles63218892tull_es
uglies7412322_uglies
wallies103320742wallies
wellies103719072wellies
willies103920152willies

Search took 4 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 Filter1786911076710.1401276364.3
2DLD Change Limit107671763.69029179.1
3Display Results76760.0302533.3
 (SQL Overall)178691763.86046293.0
 
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.