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

64 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
seahorse114559(None) 
seahorses1246161seahorses
ahorse9311512__ahorse
redhorse1245462redhorse
sawhorse1443522sawhorse
seaborne1055432seaborne
seashore1147722seashor_e
seashores1247962seashores
senhores112810992senhores
senhors103512132senhors_
teahouse1146072teahouse
beadhouse1544423beadhouse
endorse879203_endorse
ephors11311403_ephors_
hearse94114273hea__rse
henhouse1445573henhouse
horse86132653___horse
rearouse839363rearouse
rechoose13137343rechoose
rechose121312043recho_se
redhorses1345653redhorses
rehouse10311773re_house
remorse9311713re_morse
retrorse837623retrorse
sapors84118813s_apors_
savors95616103s_avors_
sawhorses1543753sawhorses
scapose1147753scapo_se
seacoast1047783seacoast
seadogs958643seadogs_
seadrome1146513seadrome
sealers74323553sealers_
seamers94719433seamers_
seaport9315603seapor_t
seaports1038463seaports
sears54744913sea__rs_
seasons72614233seasons_
seaters74028943seaters_
seaware1049633seawar_e
seawares1139333seawares
secalose1046963secalo_se
sectors93116453sectors_
seisors73212843seisors_
seizors16329013seizors_
semaphore1644353semaphor_e
semaphores1744673semaphores
senators8312953senators_
senhor93010813senhor__
senhora10348673senhor_a
senhoras11278283senhoras
seniors73413623seniors_
senores73218113se_nores
senors63620793se_nors_
sensors73514643sensors_
setose65114773se_to_se
shore85432653s__hor_e
shores94830413s__hores
sparse84516343spa__rse
spathose1345633spatho_se
stators73915583stators_
studhorse1342033studhorse
teahouses1246513teahouses
unhorse1038583_unhorse
warhorse1445343warhorse

Search took 9 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.846211218.7
2DLD Change Limit146162648.06018134.2
3Display Results64640.0331939.4
 (SQL Overall)178691648.93919990.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.