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

53 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
quanting184923(None) 
quantong1843491quantong
anting75827022__anting
bunting103718832bu_nting
canting104725902_canting
chanting143413532chanting
daunting103310402daunting
dunting93418382du_nting
equating18310112equa_ting
granting103514522granting
hanting114124482_hanting
haunting123510052haunting
hunting114317122hu_nting
jaunting16328632jaunting
lunting83817742lu_nting
munting103718772mu_nting
panting104025422_panting
planting113515382planting
punting103318442pu_nting
quacking2436742quacking
quadding2035362quadding
quaffing2434352quaffing
quailing1838402quailing
quaking2139312qua_king
quandang1943292quandang
quandong1942942quandong
quantic18279062quanti_c
quantics19276832quantics
quantify2343862quantify
quantile1747322quantile
quantity2044732quantity
quantize2645962quantize
quantizing29115392quantizing
quantongs1942312quantongs
quashing2137092quashing
questing1838272questing
quieting18228462quieting
quilting18218712quilting
quintin163810332quintin_
quintins17329862quintins
quirting18238382quirting
quitting18228832quitting
quoiting1836092quoiting
quoting17310042qu_oting
ranting84025412_ranting
scanting113914762scanting
slanting94115092slanting
squatting1934512squatting
squinting1936222squinting
taunting93510932taunting
truanting1035602truanting
vaunting12338752vaunting
wanting114220172_wanting

Search took 5 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 Filter1786911210590.406440125.6
2DLD Change Limit121059534.36027765.8
3Display Results53530.0163312.5
 (SQL Overall)178691534.78237367.4
 
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.