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

86 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
assholes114674(None) 
asshole1046791asshole_
airholes1138032airholes
armholes1347382armholes
absolves1344413abs_olves
aholds10469483a__holds
airhole1048273airhole_
aisles64721143ais__les
amoles84122193a__moles
anetholes1246673anetholes
anisoles81010123anisoles
anoles64827433a__noles
areoles71016953a_reoles
armhole1236943armhole_
ashes86230613a_sh__es
ashler9459973a_sh_ler
ashlers10319583a_sh_lers
ashless10318453a_sh_less
ashore9414613a_shore_
asphalts1344183asphalts
asphodel1442593asphodel
asphodels1541783asphodels
assailed945323assailed
assailer844823assailer
assailers943983assailers
assails769093assail_s
assaults843863assaults
assembles1354313assembles
asses55629283ass___es
assesses737383assesses
assetless943573assetless
assizes1638453ass_izes
assoiled935023assoiled
assoils776663ass_oils
assorts73310153ass_orts
assuages936273assuages
assumes967163ass_umes
assures7611403ass_ures
asswages1255053asswages
aureoles838283aureoles
azoles154614613a__zoles
casseroles1243773casseroles
dholes104914793__dholes
eyeholes1445593eyeholes
fishpoles1743633fishpoles
foxholes2144693foxholes
gasohols1243723gasohol_s
hassles103411693hass__les
hawseholes1951973hawseholes
holes84748653___holes
insoles73516243ins_oles
keyholes1844593keyholes
lassoes74613853lass_o_es
manholes13311183manholes
mudholes1444873mudholes
oilholes1146153oilholes
osmoles9138363_osmoles
ossicles1054183ossicles
ostioles839273ostioles
pestholes1448233pestholes
pieholes13168913pieholes
pinholes131810663pinholes
pishoges1446953pishoges
pistoles102514723pistoles
posoles9314883pos_oles
postholes14410453postholes
potholes13312933potholes
rassles73513923rass__les
ratholes11312413ratholes
reshoes102316033resho_es
resoles73823653res_oles
rissoles839113rissoles
safroles1136933safroles
sashes94728483sash__es
sashless1136603sash_less
shales94731253__shales
shoes85429663__sho_es
shores94830413__shores
shotes95321913__shotes
shoves124919423__shoves
soles55547923__s_oles
stoles63927673__stoles
systoles1146483systoles
tapholes1339623tapholes
tholes94919783__tholes
wholes124616773__wholes

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 Filter1786911461620.860207780.2
2DLD Change Limit146162866.44022696.0
3Display Results86860.0302866.7
 (SQL Overall)178691867.33024378.0
 
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.