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

44 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
pelagial114654(None) 
palatial10410622palatial
patagial1157172patagial
pelagic1237862pelagi_c
pelagics1345552pelagics
plagal948572p_lag_al
adagial946363_adagial
bilabial1265683bilabial
elegiac1045453_elegiac
eluvial1045853_eluvial
filarial1147863filarial
geranial949283geranial
glacial1038143_glacial
labial84714343__labial
malarial10410613malarial
melanian1048483melanian
paginal10269493p__aginal
palatal9310153pala_tal
pallial92911253pal_lial
patagia1068783patagia_
pelage9515363pelag__e
pelages10714613pelag_es
pellagra1143593pellagra_
pellagras1243383pellagras
pelletal1045723pelletal
peloria9310953peloria_
pelorian1048883pelorian
pelorias10410583pelorias
penial84120893pe__nial
peridial11411923peridial
perigeal1147543perigeal
plagiary1443643p_lagiary
playgirl1442553p_laygirl
pluvial1245433p_luvial
podagral1243373podagral
preaxial1746973preaxial
prelegal1145043preleg_al
prelogical1546683prelogical
preludial1244873preludial
pterygial1542493pterygial
puparial1246313puparial
remigial1146603remigial
telial65815363tel__ial
velaria1038923velaria_

Search took 10 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.1561145455.1
2DLD Change Limit146162449.09616068.8
3Display Results44440.0133384.6
 (SQL Overall)178691449.26519286.7
 
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.