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

48 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
squamates204559(None) 
squamate1945781squamate_
desquamates2351532desquamates
soulmates1147072soulmates
squamae1845722squama_e_
summates122610482s_ummates
aguacates1244583aguacates
aquacades2143213aquacades
desquamate2251503desquamate_
desquamated2451363desquamated
equates162012313equ__ates
glutamates1352693glutamates
hamates122917673__hamates
humates122813193_hu_mates
imamates1237653_imamates
nizamates2043263nizamates
quadrates19117793_quadrates
quamashes2343973_quamashes
quartes163314933_qua_rtes
quayages2144213_quayages
samites93118713s__amites
savates10312953s__avates
seatmates1157813seatmates
separates11310733separates
sfumatos1353343sfu_matos
shipmates1645943shipmates
soulmate1047183soulmate_
squabbles2243633squabbles
squalenes1845763squalenes
squama1736533squama___
squamation2153533squamation
squamations2272743squamations
squamose1944273squamose_
squamous1944663squam_ous
squares163714453squ__ares
squashes20207803squa_shes
squats153712963squ__at_s
squatted1835343squa_tted
squatter1735913squa_tter
squatters1834933squa_tters
squattest1844613squa_ttest
stearates939433stearates
stomates10313343s_tomates
sublates10315003s_ublates
sulfates11310793s_ulfates
summate113611663s_ummate_
summated13298833s_ummated
usquabaes2041553usquaba_es

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641488.11018328.1
3Display Results48480.0301600.0
 (SQL Overall)178691488.29621539.4
 
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.