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

76 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
mastiffs164423(None) 
mastiff1538161mastiff_
caitiffs1642882caitiffs
castoffs1644042castoffs
massifs1237742massi_fs
mastics112614782masti_cs
mastitis1039102mastitis
mastixes1738252mastixes
stiffs12389962__stiffs
bailiffs1642563bailiffs
bastiles10313353bastiles
bastings114214693bastings
bastions10411693bastions
blastoffs1743103blastoffs
caitiff1547133caitiff_
castings113614053castings
castoff1547793castoff_
distaffs1565083distaffs
dustoffs1543163dustoffs
eastings93412953eastings
fastings124011943fastings
lastings94214423lastings
maftirs1236043mafti_rs
mantids103113623manti_ds
mantis83926033manti__s
mantises10317923mantises
martians103111613martians
martinis103311613martinis
martins93322063marti_ns
mashies12318253mashi_es
masjids17175403masji_ds
maskings15448753maskings
massif11412533massi_f_
mastabas1246803mastabas
masters94628923mast_ers
mastic103119173masti__c
mastiche1547173mastiche
mastiches1647333mastiches
masting104325823masti_ng
mastitic1248263mastitic
mastix152310513masti__x
mastless102610023mastless
mastoids1177873mastoids
masts77035763mast___s
matings104516213ma_tings
matins84527783ma_ti_ns
mattings11369673mattings
mattins93316143matti_ns
mestinos1048163mestinos
mestizas1944703mestizas
mestizos1944493mestizos
midriffs1742533midriffs
miffs134512883m___iffs
mistimes12612613mistimes
motifs1139673m_oti_fs
mystics14279103mysti_cs
mystifies1745883mystifies
mystify1843563mysti_fy
nasties73520493nasti_es
pasties94529813pasti_es
pastils94416173pasti_ls
pastimes123611903pastimes
pastinas103712153pastinas
pastis84924323pasti__s
pastises103616053pastises
pontiffs1643143pontiffs
restaffs1444783restaffs
restuffs1444193restuffs
skiffs16327013__skiffs
sniffs12378843__sniffs
spiffs14328473__spiffs
staffs12349753__staffs
stiff114219243__stiff_
stuffs123810223__stuffs
tariffs1334593ta_riffs
tiffs114414883___tiffs

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit146162767.25020160.3
3Display Results76760.0332303.0
 (SQL Overall)178691767.70323197.6
 
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.