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

133 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
fatalist1131497(None) 
fatalism13310481fatalism
fatalists12310021fatalists
atavist10311092_atavist
cabalist12314502cabalist
catalyst1347312catalyst
fabulist1347672fabulist
factualist1544752factualist
fantasist1288002fantasist
fatalisms1439112fatalisms
fatalistic1546712fatalistic
fatality1438442fatality
finalist113014732finalist
kabalist14410082kabalist
metalist10519352metalist
satanist8313372satanist
totalist8315582totalist
vitalist11313392vitalist
alist56136783___alist
analyst10189323_analyst
annalist8413753annalist
arbalist10313333arbalist
atavism1238033_atavism
atavists1137583_atavists
atheist10314063_atheist
atomist92915763_atomist
atonalist9411833_atonalist
baalism11310593ba_alism
backlist16910653backlist
botanist10412033botanist
cabalism14310143cabalism
cabalists1339153cabalists
cabbalist1547643cabbalist
canalise10816213canalise
capitalist1457883capitalist
catalase1039223catalase
catalos9414163catalos_
catalysts1445513catalysts
dadaist9310103dada_ist
dialist8517763_dialist
dualist8614053_dualist
etatist7415033_etatist
fabulists1444723fabulists
facelift1645773facelift
factualism1753903factualism
factualists1653523factualists
faddist12289643fa_ddist
familism1546343familism
fantails1139693fantails_
fantasise1296243fantasise
fantasists1385503fantasists
fantast10311703fanta__st
faradise12219393faradise
faradism14188373faradism
fascist1239213fa_scist
fatal84819373fatal___
fatally1339893fatal_ly
fatalness1245773fatalness
fatless103212203fat_less
fatlike142911193fat_like
fatling113815683fat_ling
fattest102913063fat_test
fattiest113514313fattiest
fattish1359263fat_tish
fauvist1336663fa_uvist
fayalite1447053fayalite
featliest1238363feat_liest
fetialis11358663fetialis_
feudalist1356303feudalist
finalis103313663finalis_
finalise113112573finalise
finalism133010363finalism
finalists123010163finalists
fiscalist1446573fiscalist
focalise131210373focalise
formalist141910643formalist
futurist1148283futurist
hagadist1347603hagadist
halakist15158223halakist
handlist12311333handlist
idealist9310653idealist
kabalism1647043kabalism
kabalists1546293kabalists
kabbalist1744613kabbalist
legalist9512393legalist
localist101613963localist
loyalist111511133loyalist
lutanist8410273lutanist
medalist11414213medalist
mentalist11515553mentalist
metalise10416053metalise
metalists11412663metalists
metallist1159673metallist
moralist10316663moralist
muralist10312983muralist
mutualist1146403mutualist
nasalise848863nasalise
nasalism1048203nasalism
natality1139193natality
nativist11118683nativist
naturalist1048873naturalist
naturist8410813naturist
oralist7619633_oralist
paganist11411813paganist
panelist10414503panelist
pastelist1149623pastelist
racialist11411203racialist
ratals64219583ratal_s_
realist73225383_realist
ritualist948643ritualist
royalist111311983royalist
ruralist8311703ruralist
satanism1039673satanism
satanists948233satanists
satirist8313503satirist
sitarist8315283sitarist
sodalist9311883sodalist
stalest73720173_stalest
statist7317723_statist
stylist102110283_stylist
tanist6324593__tanist
tantalise91210823tantalise
tatamis939723tatamis_
titlist7312923tit_list
totalise8312503totalise
totalism10311093totalism
totalists9310753totalists
vitalise11310743vitalise
vitalism1339683vitalism
vitalists1239223vitalists
vocalist131512123vocalist
votarist111012163votarist
waitlist1147743waitlist

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621336.47022590.7
3Display Results1331330.0462891.3
 (SQL Overall)1786911336.92225814.9
 
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.