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

287 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
hafizes223598(None) 
baizes174315052ba_izes
capizes20410372capizes
hafiz20611212hafiz__
halides113416662halides
halites103221192halites
hazes174928322ha__zes
maizes175115732ma_izes
abides94719893_abides
adzes155913803_a_dzes
affines1339483affines
affixes2035503affixes
afire86215913_afire_
agatizes1838863agatizes
agnizes17328843agnizes
aides65336603_a_ides
alines65735223_alines
amazes175613473_amazes
amices105018013_amices
amides95722663_amides
amies76837683_ami_es
amines84727983_amines
animes84719593_animes
anises64826693_anises
apices104916263_apices
arabizes1969103arabizes
arises65233803_arises
asides75118873_asides
assizes1638453assizes
axises134413993_axises
axites134913833_axites
azides165113803_azides
azines155517073_azines
babies106123643babi_es
baffies153612943baffies
baffles153710683baffles
baizas173810823ba_izas
baize164717393ba_ize_
baptizes2136833baptizes
barites94322333barites
bizes165923663__bizes
braizes183112453braizes
cafes106426923caf__es
calices114321693calices
camises114218463camises
canines93724033canines
capsizes2147203capsizes
caribes113715643caribes
carices114220953carices
caries85147623cari_es
cavies114525003cavi_es
chafes145017913chaf__es
chaines124518733cha_ines
chaises124317493cha_ises
chalices15310813chalices
chamises153513313chamises
dacites101114593dacites
daises74318983da_ises
datives11310073datives
davies105020513davi_es
dazes155024143da__zes
defies104624053defi_es
defiles114016843defiles
defines114118683defines
defuzes20398303defuzes
dualizes1838823dualizes
easies64126633easi_es
facies113921593faci_es
famines123216263famines
fazes175527213__fazes
fezes175220023__fezes
fices106031163__fices
fifes114822393__fifes
files85441273__files
fines86644263__fines
fires85740753__fires
fives116027363__fives
fixes154723593__fixes
fizzes174512553__fizzes
frizes184015463_frizes
fuzes175120223__fuzes
gabies93820723gabi_es
gaffes134811103gaf_fes
gamines103618463gamines
gauzes164710633ga_uzes
gazes155425913ga__zes
ghazies2036913ghazi_es
habile11515203habile_
habited1337883habited
habits113014643habi_ts
habitues13306413habitues
habitus12338173habitus
hackees165014103hackees
hackies163418243hackies
hackles162917063hackles
hades96035113ha__des
hadiths1436023hadiths
hadjees18356383hadjees
hadjes175210403ha_djes
haeres94017033ha_eres
haes77651023ha___es
haffet15311703haf_fet
haffets1636053haffets
haffits1636193haffits
hafniums1643103hafniums
hafted134713833haf_ted
hafter124815883haf_ter
hafters134614333hafters
hafts116219463haf__ts
hagfishes1945153hagfishes
haggises1335883haggises
haggles123312483haggles
hagrides1337623hagrides
haiks125120933ha_i_ks
haikus13538293ha_ikus
hailed104122743ha_iled
hailer94720343ha_iler
hailers104017263ha_ilers
hails85231643ha_i_ls
haints94417583ha_ints
haired105117173ha_ired
hairs86225173ha_i_rs
hajes155420943ha__jes
hajis156716273haji__s
hajjes15485243ha_jjes
hakes126034303ha__kes
hakims1537303haki_ms
hales85449843ha__les
halflives1842783halflives
halfpipes1942493halfpipes
halftimes1742883halftimes
halide103417993halide_
halids104016133hali_ds
halite93624233halite_
halitus10339963halitus
halloes104021513halloes
haloes94623863ha_loes
halves124717093ha_lves
hamates122917673hamates
hames106138703ha__mes
hamzas20119013ha_mzas
hances115621283ha_nces
handles114020653handles
hangfires1643843hangfires
hankies143617763hankies
hanses95022633ha_nses
hantles104117513hantles
haoles94919803ha_oles
hapaxes1936593hapaxes
haplites1339993haplites
hardies114923233hardies
hares86255543ha__res
harmines132715133harmines
harpies123818313harpies
harries103525493harries
hashes125024803ha_shes
hassles103411693hassles
hastes95727073ha_stes
hatches153420273hatches
hates86742573ha__tes
haves116034873ha__ves
haviors1347383haviors
hawkies173311243hawkies
hawses125113993ha_wses
hayings14379393hayings
hayrides1536883hayrides
haywires1744043haywires
haze164833393ha__ze_
hazed185222203ha__zed
hazel176414813ha__zel
hazels185710083ha__zels
hazer174820233ha__zer
hazers184615953ha__zers
hazier184712403hazi_er
haziest193313003hazi_est
haziness20248513haziness
hazings20378343hazings
heavies132713873heavi_es
heezes184211643h_eezes
helices12313723helices
helixes1739133helixes
hepatizes2347823hepatizes
heroizes202610983heroizes
hertzes1938293hertzes
hides95129423h__ides
hies74842833h__i_es
hikes125426983h__ikes
hires86134343h__ires
hives116925513h__ives
hoagies112811993hoagi_es
hoises94823673h_oises
holies94630033holi_es
homies114524723homi_es
homines123518633homines
humanizes2347533humanizes
hyalines14169323hyalines
hyalites14208833hyalites
infixes17238133infixes
iodizes173911723iodizes
ionizes162813343ionizes
jazzes21347883ja_zzes
kafirs13306983kafi_rs
kyanizes24205283kyanizes
ladies75124883ladi_es
laicizes1937403laicizes
lapides103012043lapides
lapises93513463lapises
latices9313763latices
lawines103313563lawines
lazes145129573la__zes
lazies154418783lazi_es
mafias113913573mafi_as
mailes84329113ma_iles
maize164618553ma_ize_
malices114316623malices
malines93625603malines
mamies104626243mami_es
marines93928013marines
mavies114923193mavi_es
mavises122812993mavises
maxixes1535253maxixes
mazes165632173ma__zes
naives94914223na_ives
natives10310823natives
navies95218623navi_es
offices1536243offices
paries84742513pari_es
parises94827183parises
patines95225763patines
pavises125315493pavises
phizes20389133_phizes
prizes173819813_prizes
rabies85226013rabi_es
radices102314263radices
radixes15259343radixes
raffles133611843raffles
raises64826543ra_ises
ramies84630463rami_es
rapines95120863rapines
ratines75328583ratines
ratites74920683ratites
ravines104220233ravines
razes145032703ra__zes
razzes144910063ra_zzes
realizes173116843realizes
refiles104122423refiles
refines105426343refines
refires104820313refires
refixes174813173refixes
resizes164216843resizes
sabines94318483sabines
safes85226723saf__es
saices84221803sa_ices
salines74029413salines
samites93118713samites
sanies63031953sani_es
satires72617573satires
savines104417633savines
seizes154317533_seizes
shavies134213203shavi_es
sizes146727763__sizes
taffies133012693taffies
tafias93111963tafi_as
talipes9611603talipes
tamises92715973tamises
tapises92914013tapises
taxies135817333taxi_es
taxites1449673taxites
unfixes17238113unfixes
upsizes18297163upsizes
vahines133410523vahines
valines104520213valines
valises103516263valises
varices123313573varices
varies94330873vari_es
wadies105121203wadi_es
waffies163611443waffies
waffles16329983waffles
wahines133111173wahines
waives123714183wa_ives
walies95324523wali_es
waltzes1935953waltzes
wavies125019843wavi_es
wizes174723343__wizes
zaffres22324993zaffres
zaires1539703za_ires
zanies153219673zani_es

Search took 10 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.203880251.2
2DLD Change Limit1340272879.14014663.8
3Display Results2872870.300956.7
 (SQL Overall)1786912879.64318530.6
 
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.