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

61 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
razor14301260(None) 
razer144824271razer
razors154711661razors
arbor74818112arbor
ardor64617862ardor
armor75118052armor
azo128233392_azo_
azon135725052_azon
bazar163816002bazar
bazoo163815672bazoo
brazer174917532brazer
favor114712452favor
gator64416042gator
gazar154612982gazar
gazer155720072gazer
gazoo153112872gazoo
grazer164815762grazer
hazer174820232hazer
kazoo183311532kazoo
labor75117312labor
lazar144113642lazar
mahzor2035112mahzor
major145212922major
manor78023932manor
mayor106616622mayor
mazer165722422mazer
orator6314532orator
payor105413842payor
racer75233022racer
racon75422142racon
radar61316722radar
radon64620502radon
raker94529792raker
rancor8810372rancor
raper74932752raper
raptor83912822raptor
rarer54731702rarer
raser55633412raser
rater54943282rater
rato45436972rato_
ratos55528762ratos
raver85631492raver
rawer84623732rawer
rayon83815702rayon
raze135235432raz_e
razed155027982razed
razee145827802razee
razers154919612razers
razes145032702razes
razored1736332razored
razz125219422raz_z
rigor62714052rigor
rotor55519732rotor
rumor71011322rumor
sapor75119252sapor
savor85417942savor
tabor75518392tabor
valor83614892valor
vapor104013092vapor
vizor173010092vizor
wazoo173011172wazoo

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit53800611.76630464.3
3Display Results61610.0302033.3
 (SQL Overall)178691612.10984727.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.