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

135 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
isolation931164(None) 
insolation10410211insolation
isolations10310691isolations
solation8916151_solation
desolation11311402desolation
illation8311942i_llation
immolation1446102immolation
inflation12311092inflation
insolations1149182insolations
insulation10311662insulation
iodation9310382i_odation
isolating1039742isolating
isolator847532isolat_or
solations9814622_solations
solution889592_solution
solvation1237772_solvation
violation1238442violation
ablation10312433_ablation
abolition1147053abolition
absolution1244403absolution
acylation1448653acylation
adoration10311313adoration
adulation10311013adulation
alation72920553__alation
avocation14168993avocation
bilocation1446123bilocation
chelation1439963chelation
cisplatin1344713cisplati_n
collation11313993collation
conation101420883_conation
consolation13410983consolation
dealation10313003dealation
deflation13310653deflation
delation92318083_delation
desolations12310593desolations
dilation92215463_dilation
dislocation14147503dislocation
disrelation1248813disrelation
dissolution12145023dissolution
donation91513783_donation
dotation91412733_dotation
elation73620453__elation
emulation11312393emulation
epilation11312963epilation
escalation1248873escalation
etiolation1048533etiolation
evocation142010293evocation
evolution12117093evolution
exsolution1743763exsolution
fellation1238843fellation
flotation1267813flotation
foliation121110793_foliation
gelation93014433_gelation
halation11313853_halation
ideation9310493i_deation
idolator946243idolat_or
idolization2147763idolization
illations9311393i_llations
imitation11510853imitation
immolations1545473immolations
impletion1345403impletion
inflations13310323inflations
inhalation13107663inhalation
innovation1345643innovation
inoculation1358713inoculation
insolating1149153insolating
insulations11310233insulations
intonation10410263intonation
invocation1547543invocation
involution1345943involution
iodations1039113i_odations
isatin6412213is__ati_n
isolate7313923isolat__e
isolated9410523isolat_ed
isolates8613513isolat_es
isolationism1453943isolationism
isolationist1255883isolationist
isolators947513isolators
iteration9515033iteration
lallation939493lallation
lobation102110553_lobation
location102113913_location
mislocation15126413mislocation
notation81414603_notation
novation111710013_novation
oblation1039863_oblation
oration71617713__oration
osculation1249673osculation
ovation101510023__ovation
ovulation1238983ovulation
ozonation1845673ozonation
phonation1439393phonation
pixilation1945913pixilation
potation101716783_potation
probation13412183probation
pronation11415703pronation
proration11415983proration
quotation18146973quotation
reflation12412333reflation
relation82619773_relation
resolution1097733resolution
rogation91612053_rogation
rotation81615453_rotation
saltation9312003_saltation
salvation1239293_salvation
scalation11311073scalation
sedation9312453_sedation
sibilation12128773sibilation
siltation939213siltation
simulation1269583simulation
sinuation9310413sinuation
situation949423situation
solanin7311943_solani_n
solatia7312253_solati_a
solating9315593_solating
solatium1067613_solatium
solion6616383_sol__ion
soliton7410233_solit_on
solutions988883_solutions
solvations1336833_solvations
sorption1037513_sorption
spoliation1248423spoliation
station72717243_s_tation
sublation11311013sublation
sudation9310803_sudation
sulcation11710733_sulcation
sulfation1288783_sulfation
ululation938093ululation
vallation1239743vallation
violations1337963violations
visitation1348593visitation
vocation132311983_vocation
volition1179173_volition
volution1198603_volution
zonation171410723_zonation

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411356.57622603.6
3Display Results1351350.0632142.9
 (SQL Overall)1786911357.06225303.2
 
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.