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

86 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
defoamers1528525(None) 
defamers14258521def_amers
defoamer14276211defoamer_
deformers15266531deformers
defacers14237992def_acers
defamer132710322def_amer_
defames132812252def_ame_s
defeaters13289102defeaters
deflaters13298702deflaters
defoamed15356242defoame_d
defoams1336192defoam__s
defoggers1543052defoggers
deforcers15265502deforcers
deformer14247942deformer_
defrayers1644172defrayers
dewormers15255192dewormers
foamers123812102__foamers
reformers14246402reformers
befoulers1443123befoulers
dealers84118613de__alers
debasers11377903de_basers
debaters113511923de_baters
deboners11268113debo_ners
decayers14307963de_cayers
declaimers1543593declaimers
declarers1236423declarers
decoders122810413deco_ders
decoyers14287713deco_yers
defacer132810363def_acer_
defaces133213403def_ace_s
defame123212433def_ame__
defamed14309833def_ame_d
defeater122611663defeater_
defenders1436363defenders
deferrers13115153deferrers
defers105116943def___ers
defiers113913993def__iers
defilers12439473def_ilers
definers124211193def_iners
deflater123211603deflater_
deflates123013943deflate_s
deflators13348153deflators
deflowers16145643deflowers
defoam1238563defoam___
defoaming1645653defoaming
defogger1443533defogger_
deforcer14246903deforcer_
deforces14248403deforce_s
deformed15248263deforme_d
deforms1337803deform__s
defraggers1642013defraggers
defrauders1541993defrauders
defrayer1534933defrayer_
defrosters1443363defrosters
defusers12487363def_users
degames113312623de_game_s
degraders12245933degraders
dehorners1344743dehorners
delayers12268663de_layers
delousers1044663delousers
deporters1277793deporters
deposers11359243depo_sers
depravers1534683depravers
desolaters1146043desolaters
devourers1344093devourers
dewaters122910723de_waters
dewormer14256323dewormer_
dormers104313913d__ormers
dreamers11369003d_reamers
effacers16244233_effacers
flamers124616363__flamers
foamer114714313__foamer_
formers128217953__formers
framers125113823__framers
inflamers1455213inflamers
informers14206133informers
metamers1249623me_tamers
performers17164103performers
reamers94221083re__amers
reformer13217953reformer_
reframes1338993reframe_s
reloaders1036423reloaders
roamers93713463__roamers
seamers94719433se__amers
tetramers1146443tetramers
venomers1336703veno_mers

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 Limit148641868.31317880.5
3Display Results86860.0302866.7
 (SQL Overall)178691868.49921024.9
 
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.