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

70 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
gallanted114589(None) 
ballasted1245452ballasted
galavanted1552512galavanted
galeated104111572galea_ted
galivanted1542552galivanted
gallant83517112gallant__
gallantly1344242gallantly
gallantry1343352gallantry
gallants93310372gallant_s
gallate83417122galla_te_
gallates92815522galla_tes
galleted1038212gall_eted
gallivanted1651772gallivanted
garlanded1244692garlanded
ablated102513443_abla_ted
alated75625143_a_la_ted
allanite8411093_allanite_
allanites949793_allanites
allantoid1094853_allantoid
allayed11138063_alla_yed
allotted986873_allotted
atlantes838553_atlantes
balanced1356513ba_lanced
ballaster1145973ballaster
balloted1189043ball_oted
callant94121223callant__
callants104112143callant_s
collated113615063colla_ted
explanted1944973explanted
falcated1438473falca_ted
fellated1239563fella_ted
galatea839943ga_la_tea
galeate83916783galea_te_
gallanting1245343gallanting
gallantries1254113gallantries
galled84622853gall___ed
galleried1146923galleried
gallied94114993gall__ied
gallooned1144463gallooned
galloped12107143gall_oped
gallused1034193gall_used
galvanised1543463galvanised
galvanized2444273galvanized
garland948703garlan__d
garmented1345883garmented
gelated93615633g_ela_ted
gellant83214053gellant__
gellants9308283gellant_s
glanced11439233g__lanced
gleaned9349423g_lean_ed
glinted9399373g__linted
gloated93511533g_loa_ted
granted94715103g__ranted
implanted1475493implanted
lalland83810173lallan__d
palleted1139863pall_eted
palliated1238493palliated
palmated132511003palma_ted
palpated13249763palpa_ted
parlante1039683parlante_
planted103516123__planted
replanted1248063replanted
slanted83514743__slanted
talented938423ta_lented
tallaged10257923talla_ged
unplanted1236853unplanted
valanced1475463va_lanced
vallate103016563valla_te_
valuated12239203valua_ted
warranted1345013warranted

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 Filter1786911486410.203880251.2
2DLD Change Limit148641706.81321817.3
3Display Results70700.0302333.3
 (SQL Overall)178691707.04625360.6
 
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.