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

84 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
cullies9441996(None) 
bullies94121891bullies
collies94326581collies
cullied104012351cullied
cullis84115991culli_s
cullises103111311cullises
gullies84717311gullies
sullies74122231sullies
allies63827672_allies
ballies93725742ballies
bellies94023722bellies
billies93923502billies
bullied104514812bullied
bullier94116432bullier
bulliest104314502bulliest
callees94117782callees
challies133915642challies
chilies124218302chilies
chillies134113482chillies
colies84837052c_olies
collides113214472collides
collie83621992collie_
collied103316682collied
collier93618152collier
colliers103613582colliers
collins93419832collins
coolies93824962coolies
cubbies133312882cubbies
cuddies113313262cuddies
culches143710742culches
culexes1636992culexes
culices113713122culices
cullays12347702cullays
culled94022472cull_ed
culler84322252cull_er
cullers93418852cullers
cullet84727312cull_et
cullets94015612cullets
culling103921302culling
cullion91910232cullion
cullions10219222cullions
culls75425812cull__s
curies84934022cu_ries
curlier93314182curlier
curliest102713122curliest
curries93723162curries
cuties84927362cu_ties
cutlines102413272cutlines
cutties93118842cutties
dallies84023192dallies
dellies83622212dellies
dillies84122162dillies
dollies83620982dollies
fellies104119742fellies
fillies103420252fillies
follies103618942follies
gallies84122712gallies
gillies84120962gillies
gullied93812062gullied
hollies103420812hollies
hulloes104113922hulloes
hurlies103315332hurlies
jellies143816532jellies
jollies143516272jollies
kellies113516852kellies
killies113318112killies
lollies73116922lollies
mollies93420232mollies
muhlies1238932muhlies
mullites10411642mullites
nellies73418722nellies
outlies72421992outlies
rallies73823342rallies
sallies73227812sallies
sillies73425082sillies
sulkies114315762sulkies
sullied83714482sullied
tallies73624602tallies
tellies73820512tellies
tulles63218892tull_es
uglies7412322_uglies
wallies103320742wallies
wellies103719072wellies
willies103920152willies

Search took 5 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.406440125.6
2DLD Change Limit107671843.92327446.1
3Display Results84840.0302800.0
 (SQL Overall)178691844.35940993.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.