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 “hollands” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

123 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
hollands1224727(None) 
holland11349471holland_
bollards11339152bollards
collards113310192collards
holards1148432ho_lards
hollaed11359852hollaed_
hollas94616902holla__s
homelands1545442homelands
lallands9338562lallands
lowlands1244372lowlands
norlands936442norlands
pollards11299522pollards
solands84412342so_lands
alands75418373__alands
badlands1236673badlands
ballads104212913balla_ds
bollard103210503bollard_
callans94518473callan_s
callants104112143callants
chollas123811353cholla__s
coleads102911423colea_ds
collages113514233collages
collard103712923collard_
collars93816573colla_rs
collates103019143collates
collins93419833collin_s
colloids11310173colloids
commands15318823commands
coolants1039943coolants
cowhands1765263cowhands
croplands1445373croplands
docklands1743153docklands
dollars83311023dolla_rs
dolmans10479683dolman_s
downlands1453853downlands
dullards1045493dullards
elands74914773__elands
fenlands1245183fenlands
filmlands1542903filmlands
forelands1347173forelands
foulards12266463foulards
gallants93310373gallants
garlands1038323garlands
gellants9308283gellants
glands85314403__glands
goliards1045133goliards
gormands1266563gormands
hallahs133912463halla_hs
halliards13104933halliards
halyards1576243halyards
hands95327383h___ands
hatbands1446293hatbands
headlands1444903headlands
highlands17114113highlands
hoards104912623ho__ards
hodads1147963ho_da_ds
hogans105914313ho_gan_s
hogmanes1446783hogmanes
holard10410573ho_lard_
holdalls1244333holdalls
holdings13297743holdings
holds94623243ho_l__ds
holla84918493holla___
hollaing12167093hollaing
hollandaise1551423hollandaise
hollers103818233holl_ers
hollies103420813holl_ies
holloaed12157393holloaed_
holloas103814943holl_oas
holloed113812753holloed_
holloes103818193holl_oes
holloos104013583holl_oos
hollos95320633holl__os
hollows134412333holl_ows
homeland1446233homeland_
honans94814503ho_nan_s
honorands1345023honorands
hotlines11811643hotlines
hotlinks1574193hotlinks
hounds104413133ho__unds
husbands1444763husbands
inlands838783_inlands
islands837323_islands
lalland83810173lalland_
lallans74113533lallan_s
lands65426903___lands
llanos6108333__llanos
lowland1134693lowland_
mallards1138323mallards
midlands1245543midlands
mollahs12328283molla_hs
moorlands1244203moorlands
norland837163norland_
ollas54218283_olla__s
outlands988563outlands
plowlands1542583plowlands
poblanos1244993poblanos
pollacks1656373pollacks
pollard103511143pollard_
pollens93713303pollen_s
poulards11288233poulards
relands85214883_relands
rimlands1145243rimlands
robands10219863ro_bands
rollings9419953rollings
shetlands1343743shetlands
snowlands1343573snowlands
soland75115043so_land_
solanos74412853so_lanos
solans64122493so_lan_s
soldans83210403soldan_s
sunlands936383sunlands
thousands1342313thousands
tolanes74216313to_lanes
tolans64319273to_lan_s
tollages92410193tollages
trolands936423trolands
uplands1036943_uplands
volcanos1344733volcanos
volplanes1444673volplanes
wetlands1244763wetlands
wildlands1443273wildlands
woodlands1444153woodlands

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.1561145455.1
2DLD Change Limit1461621237.89018525.0
3Display Results1231230.0462673.9
 (SQL Overall)1786911238.09222082.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.