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

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

107 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
gallets8351740(None) 
ballets93719511ballets
callets93821701callets
gallet73630851gallet_
galleta8399641galleta
galletas9308131galletas
galleys11369711galleys
gullets84013711gullets
mallets93318491mallets
pallets93919301pallets
sallets73719651sallets
wallets103914831wallets
aglets73915682_aglets
allees64521482_allees
alleys95113302_alleys
allots64019172_allots
ballers94421012ballers
ballet84733972ballet_
ballots94116032ballots
billets94516152billets
bullets93516392bullets
cablets114216342cablets
callees94117782callees
callers94221962callers
callet84536762callet_
camlets114314622camlets
caplets114914522caplets
collets93517902collets
cullets94015612cullets
dalles74222062dalle_s
eaglets84111662eaglets
fallers103917992fallers
fillets103414752fillets
gables94222332gable_s
gadgets10348682gadgets
galeas74618512ga_leas
gales65442482ga_le_s
galilees936332galilees
galiots82311322galiots
gallants93310372gallants
gallate83417122gallate
gallates92815522gallates
galleass935052galleass
galled84622862galle_d
gallein8299042gallein
galleins9258692galleins
galleon8278712galleon
galleons9258442galleons
gallery11468742gallery
galleted1038212galleted
galley104215452galle_y
gallies84122712gallies
galliots9228682galliots
gallnuts943922gallnuts
gallons83015952gallons
galloots9268962galloots
gallops103211652gallops
gallous82813952gallous
gallows113513512gallows
galls64729322gall__s
gallus74313202gall_us
galoots82410792galoots
gannets83811442gannets
gantlets9308902gantlets
gaolers83511562gaolers
gapless10349992gapless
gargets94614572gargets
garnets84115402garnets
garrets84413622garrets
gaskets12348152gaskets
gasless8319012gasless
gaults74112782gaul_ts
giblets103210422giblets
giglets93211552giglets
gillers84216902gillers
gillnets934732gillnets
gimlets10338432gimlets
gleets75315052g_leets
goalless935722goalless
goblets103210182goblets
goglets9379782goglets
guglets9369692guglets
gullet74924832gullet_
gulleys11438522gulleys
hallels103310132hallels
hamlets123211402hamlets
haslets102510862haslets
mallees93315972mallees
mallet84433052mallet_
malleus92911312malleus
millets94216842millets
mullets93614782mullets
palets85122312pa_lets
pallet84232652pallet_
pellets94014782pellets
pullets94015162pullets
rillets74216152rillets
sallet63734542sallet_
samlets93813552samlets
tablets94714382tablets
tallest7317092tallest
tallits73215992tallits
valets93715622va_lets
valleys13407482valleys
varlets10411572varlets
wallet93327092wallet_
willets104414322willets

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit1076711073.11034620.9
3Display Results1071070.0333242.4
 (SQL Overall)1786911073.51650822.2
 
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.