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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

56 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
franker14351018(None) 
cranker133612781cranker
flanker143911291flanker
franked153610051franked
frankers15348351frankers
ranker105021901_ranker
banker124222732_banker
blanker134612022blanker
brander103915822brander
branner94212372branner
canker124422522_canker
cracker153114172cracker
cranked143812842cranked
crankier14339162crankier
danker114319662_danker
drinker12349472drinker
drunker12326632drunker
faker124824592f_a_ker
fanner94218182f_anner
flaker134916172fla_ker
flanger113412622flanger
flanked153710642flanked
flanken14226762flanken
flankers15349302flankers
flunker14389362flunker
frailer10319942frailer
framer114817442fra_mer
frank124417512frank__
frankest1536962frankest
frankly17315632frankly
franks134912732frank_s
frater94520592fra_ter
frisker14389272frisker
fronter103611582fronter
funker133915762f_unker
grander93315872grander
granger93514212granger
granter84117132granter
hanker134622092_hanker
lanker104123002_lanker
prancer113613382prancer
pranked143712092pranked
prinker133412742prinker
racker124824552_racker
raker94529792_ra_ker
ranger73925522_ranger
ranked114620742_ranked
rankers113217462_rankers
ranter63826822_ranter
skanker10268482skanker
spanker133612352spanker
swanker14369482swanker
tanker104521122_tanker
thanker14309592thanker
tracker133515172tracker
wanker134219972_wanker

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.1561145455.1
2DLD Change Limit107671563.67029338.1
3Display Results56560.0331697.0
 (SQL Overall)178691563.85946305.0
 
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.