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

55 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
coveralls144708(None) 
coverall1347601coverall_
overalls11410391_overalls
coverable1649102coverable
coverages1538832coverages
coveralled1644182coveralled
overall10411082_overall_
overcalls1447202_overcalls
coaevals1344553coaeva_ls
coevally1646283co_evally
coevals1237873co_eva_ls
conepatls1385343conepatls
contrails11410543contrails
corals85325143co__ra_ls
cornballs1346313cornballs
corrals93713853co_rra_ls
covenants1445893covenants
coverage1438733covera_ge
coverers132712123cover_ers
coverings15217893coverings
coverless1436803coverless
coverlet13413013cover_let
coverlets1437053coverlets
coverlid1445943cover_lid
coverlids1544753coverlids
covers114627963cover___s
coverslip1643273coverslip
coverslips1743343coverslips
covertly1655763cover_tly
coverts124813813cover__ts
coverups1544063cover_ups
covetable1648163covetable
curveballs1751993curveballs
dovetails1343813dovetails
gomerals1147443gomera_ls
overable13513573_overable
overacts1339653_overacts
overages12513833_overages
overalled1339073_overalled
overarms13258383_overarms
overawes14511183_overawes
overbills1446603_overbills
overcall1337673_overcall_
overfills1545703_overfills
overhauls1545513_overhauls
overkills1644873_overkills
overlaps13219523_overlaps
overlays14239693_overlays
overplus1336063_overplus
oversales12313143_oversales
oversalts1238163_oversalts
oversells1236973_oversells
overtalks1645663_overtalks
severally1546243severally
severals1137593severa_ls

Search took 7 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.423422437.4
2DLD Change Limit148641556.50022867.8
3Display Results55550.0301833.3
 (SQL Overall)178691556.95325699.8
 
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.