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 “faggoty” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

63 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
faggoty154286(None) 
faggot1139051faggot_
faggotry1641671faggotry
faggots1234861faggots
maggoty1444011maggoty
faggoted1443102faggoted
faggy136514372fagg__y
fagot9323402fa_got_
fagots1039962fa_gots
maggot10311712maggot_
maggots1136562maggots
agony96415653_a_gony
agouty10366913_agouty
argosy1036423_argosy
argot67728653_argot_
argots74116033_argots
baggily1436043baggily
baggy125615683bagg__y
biggety1434433biggety
biggity1435013biggity
carroty1248943carroty
factory15108343factory
faculty1535573faculty
fagged124717703fagg_ed
faggier12309843faggier
fagging133714763fagging
faggoting1543313faggoting
fagoted1236073fa_goted
fagoter1135883fa_goter
falsity1335903falsity
fatty115117413fa__tty
fatuity1336043fatuity
faulty12429363fa_ulty
fidgety15384893fidgety
flaggy14415923flagg__y
flighty17347433flighty
foggily1535053foggily
foggy136714543fogg__y
footy115820533f__ooty
forgot104318133forgot_
fuggily1534963fuggily
fuggy135411673fugg__y
gadgety13356163gadgety
gargety12388043gargety
haughty17334643haughty
jaggary19304863jaggary
jaggery19336903jaggery
jaggy175913143jagg__y
jargony1834493jargony
magot8326393ma_got_
magots9312363ma_gots
naggy106612823nagg__y
naughty14445623naughty
nuggety1234313nuggety
parroty1247863parroty
paughty16294323paughty
raggedy13334663raggedy
raggy106116573ragg__y
saggy105917463sagg__y
waggery15276903waggery
waggly14347293wagg_ly
waggon1136393waggo_n
waggons1235503waggons

Search took 8 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 Filter1786911340270.403443402.0
2DLD Change Limit134027636.67320085.0
3Display Results63630.0163937.5
 (SQL Overall)178691637.09225196.1
 
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.