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

163 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
imagines113746(None) 
imagine1037871imagine_
imagined1254781imagined
imaginer1144301imaginer
imaginers1243691imaginers
imagings1234541imagings
images91411452imag__es
imaginal1144902imaginal
imaging1138072imagin_g
imagisms1344902imagisms
imagists1175112imagists
imagoes10126402imag_oes
imines84918342im__ines
isatines8310652isatines
malines93625602_malines
marines93928012_marines
reimagines1343982reimagines
simazines2044862simazines
acarines10314343acarines
agenes74720253__agenes
agings86312673__agings
agones75719863__agones
alanines8314793alanines
alines65735223__alines
amarones10311353amarones
amidines113010853amidines
amines84727983__amines
ammines11312673am_mines
azines155517073__azines
caginess11310303_caginess
canines93724033_canines
chaines124518733cha_ines
cyanines132710543cyanines
diamines11311613diamines
diazines1838693diazines
domaines11611063doma_ines
draglines1145993draglines
emetines10611053emetines
enamines101112103enamines
engines81114463_engines
etamines101611793etamines
examines17128773examines
fagins10513863_fagin_s
famines123216263_famines
flamines13311623flamines
flavines1437893flavines
gamines103618463_gamines
gradines103615253gradines
guanines989773guanines
hematines141312183hematines
hoagies112811993hoagi_es
hyalines14169323hyalines
ibogaines1243813ibogaines
image81411283imag__e_
imaged1097753imag__ed
imager9108113imag__er
imageries1246783imageries
imagers10107753imag_ers
imaginaries1453713imaginaries
imaginary1552503imaginary
imagining1345413imagining
imagism1285073imagi_sm
imagist1077323imagi_st
imagos9117543imag__os
imamates1237653imamates
imbibes1334673im_bibes
imides94515333im__ides
imine75821043im__ine_
immies102412423im_mi_es
immixes1835063im_mixes
immunes1136083im_munes
impaints1236243impaints
impatiens1345733impatiens
impinges13297423im_pinges
impings12348543im_pings
implies11312113impli_es
impones112712253im_pones
imprints1247303imprints
inanes62519803ina__nes
inclines10313133inclines
indamines1247513indamines
inosines8312703inosines
intines7921113i_ntines
intwines1138043intwines
iodines83616633i_odines
isagoges1044143isagoges
isatine7311753isatine_
isatins7310763isatin_s
isogones9217993isogones
isolines8312303isolines
lagunes8148523_lagunes
lawines103313563_lawines
limacine1246003limacine_
machines15312883_machines
magazines2145633_magazines
mages85036023_mag__es
magians10310753_magians
magics115311613_magi_cs
magilps1234083_magilps
magnet9320663_mag_net
magnets10311143_mag_nets
magpies12310363_magpies
mailes84329113_ma_iles
mains75635093_ma_in_s
maizes175115733_ma_izes
makings145413153_makings
malices114316623_malices
maline84529083_maline_
mamies104626243_mami_es
manes76648953_ma__nes
manginess122010413_manginess
margined1237743_margined
margins103815193_margin_s
marinas93519373_marinas
marine84230403_marine_
mariner93315993_mariner
mariners103113863_mariners
marlines103818713_marlines
matinee92415613_matinee
matinees102110423_matinees
matiness102114743_matiness
matings104516203_matings
matins84527783_matin_s
mavies114923193_mavi_es
mavins115119183_mavin_s
mavises122812993_mavises
maxixes1535253_maxixes
mayings134410503_mayings
maziness19239543_maziness
midlines112613333midlines
millines102718063millines
mines75651953_m__ines
misgives14329283misgives
murines93718223_murines
mutines93117823_mutines
opalines10311423opalines
oxazines2434073oxazines
pagings114411063_pagings
patines95225763_patines
pralines102217723pralines
rapines95120863_rapines
ratines75328583_ratines
ravines104220233_ravines
reagins84215643reagin_s
reimagine1244773reimagine_
reimagined1442893reimagined
romaines10512513roma_ines
sabines94318483_sabines
salines74029413_salines
savines104417633_savines
simazine1945363simazine_
smaltines1136993smaltines
staginess1038753staginess
stagings10378343stagings
stanines85115663stanines
taglines92210823_taglines
timelines1148433timelines
umangites1244483umangites
vaginas11298813_vaginas
vahines133410523_vahines
valines104520213_valines
vitamines1446543vitamines
wahines133111173_wahines

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.203880251.2
2DLD Change Limit1461621637.25020160.3
3Display Results1631630.0632587.3
 (SQL Overall)1786911637.51623774.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.