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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

157 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
impalas1123695(None) 
impala10256941impala_
impales113311761impales
empales112411432empales
imbalms1334552imbalms
impacts13266502impacts
impairs1135822impairs
impale102811662impal_e
impaled12288512impaled
impaler11298392impaler
impalers12226972impalers
imparks15276662imparks
imparts11298532imparts
impawns1433322impawns
impels10389522impel_s
tampalas1245472tampalas
alas46358123___alas
alpacas1137073alpacas
ampules1189433ampules
ampuls1098893ampul_s
appalls11337743appalls
appals104812943appal_s
argalas84011093argalas
balas76937213__balas
cabalas113516003cabalas
cicalas1139303cicalas
coalas87418963_coalas
copalms13367543copalms
copals105018943copal_s
copulas113811573copulas
cupolas11277753cupolas
dimples122813213dimp_les
embalms1335333embalms
empale102611263empal_e
empaled12288953empaled
empaler11288353empaler
empalers12226743empalers
galas65731643__galas
gimbals12257823gimbal_s
gimmals12225823gimmal_s
halalas104214083halalas
hawalas13348353hawalas
ideals75012503ideal_s
iguanas835383iguanas
images91411463im_ages
imagos9117553im_agos
imams91511113im_a_ms
imaums10106303im_aums
imbalm1246323imbal_m
imbarks15326613imbarks
impact122310453impa_ct
impaint11511223impaint
impaints1236243impaints
impair1036003impa_ir
impaling1338253impaling
impanel1137093impanel
impanels1245233impanels
impark14287073impa_rk
impart102715143impa_rt
impasse11246463impasse
impasses12257523impasses
impaste11258003impaste
impastes12238193impastes
impasto11275193impasto
impastos12244833impastos
impavid1544553impavid
impawn1333263impa_wn
impearls1253883impearls
impedes124310093impedes
impel95711773impel__
impends12376803impends
impetus1144893impetus
imphees1436693imphees
impings12348553impings
impious1137063impious
impis96213853imp__is
implant11311333implant
implants1237883implants
implead12315823implead
impleads13294593impleads
impled113812513imp_led
implies11312123implies
imply124911843imp_l_y
impones112712253impones
imports11309623imports
imposes113213683imposes
imposts11269003imposts
impresa1134753impresa
impresas1244453impresas
impress1137773impress
improvs1435003improvs
imps86221123imp___s
impugns1243333impugns
impulse1135113impulse
impulses1235223impulses
imputes1138083imputes
indabas1045853indabas
infalls1038943infalls
inhales10511863inhales
inwalls1037283inwalls
kabalas133911063kabalas
kamalas13339123kamalas
koalas104011663_koalas
limpas105513083limp__as
malar76424443_m_alar
malars85020683_m_alars
males75049793_m_ales
malls76233433_m_alls
malms95021553_m_alms
malts76331753_m_alts
mamas95930783_m_amas
manas76240433_m_anas
maples104819423_maples
maras75443303_m_aras
masalas9312073masalas
masas75630413_m_asas
mayas105924383_m_ayas
meals75933383_meal_s
molas75132093_m_olas
moolas83615593_moolas
mullas84215933_mullas
nalas55528363__nalas
napalms1144033napalms
nopales93812523nopales
nopals84914023nopal_s
nyalas936903_nyalas
omphalos1543693omphalos
opals75718353_opal_s
pacas96029403__pacas
palais8420423__palais
pales75753803__pales
palls74332563__palls
palms94921753__palms
palps94719563__palps
pals66951353__pal_s
papas94927493__papas
papayas1437273papayas
paras76143053__paras
pimples133012423pimp_les
pipals104213643pipal_s
qabalas18289503qabalas
rimples113114223rimp_les
sepals85217383sepal_s
simples113014943simp_les
smalls84514123sm_alls
smalts85214893sm_alts
spales84728103_spales
spalls84217343_spalls
talas55935893__talas
tambalas1237033tambalas
tampala1136613tampala_
tapalos938813tapalos
tepals85415043tepal_s
timbales12227843timbales
timbals11239533timbal_s
timpana11226133timpana_
wimples143311173wimp_les

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.403443402.0
2DLD Change Limit1340271575.69023554.8
3Display Results1571570.0632492.1
 (SQL Overall)1786911576.15629027.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.