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

69 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
mammoth134498(None) 
mammoths1442851mammoths
mammate104411272mammate
mammati10398372mammati
mammet94319252mammet_
mammets103911112mammets
mammock1664392mammock
mammon939642mammo_n
mammons1048512mammons
marmot10318742marmot_
marmots11311512marmots
matzoth2144332matzoth
ammo85520133_ammo__
ammono1047373_ammono
ammos94815823_ammo_s
azoth17389903_a_zoth
badmouth1643583badmouth
dammit11311133dammit_
gammon1138903gammo_n
gammons1237973gammons
halloth134111253halloth
hammock2064633hammock
hawkmoth2351823hawkmoth
maggot10311713maggot_
maggots1136563maggots
maggoty1444013maggoty
magmata1237463magmata
magot8326393ma_got_
magots9312363ma_gots
maloti8313213ma_loti
mambo115215743mambo__
mamboed14417623mamboed
mamboes135011823mamboes
mambos125414493mambo_s
mamma86317913mamm__a
mammae94613213mamm_ae
mammal95112753mamm_al
mammals10389273mammals
mammary1335993mammary
mammas94616403mamm_as
mammatus1144233mammatus
mammee94417853mamm_ee
mammees104411143mammees
mammer94218863mamm_er
mammers104615693mammers
mammey124310893mamm_ey
mammeys13376723mammeys
mammie94313783mamm_ie
mammies104314763mammies
mammitis1145593mammitis
mammocks1763893mammocks
mammy115215163mamm__y
marmite112413993marmite
mascot104016073mascot_
mascots113910343mascots
math95437453ma___th
matzoh2035483matzo_h
matzot17710983matzot_
maumet103518883maumet_
maumets11369693maumets
midmonth1642723midmonth
mikvoth1962143mikvoth
moth96731333___moth
motmot10311073motmot_
motmots1166133motmots
rammish1437563rammish
smooth11259203_smooth
warmouth1644143warmouth
warmth1477933warm_th

Search took 7 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 Filter1786911340270.1401276364.3
2DLD Change Limit134027696.65620136.3
3Display Results69690.0302300.0
 (SQL Overall)178691696.82626178.0
 
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.