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 “conservationista” with Change Limit: [1] [2] [3] [4] [5] [6] [7]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
conservationist2084021conservationist_
conservations1849093conservation_s__
conservation1749404conservation____
conservational1955344conservation__al
constructionist1984034constructionist_
cooperationist1864224cooper_ationist_
cooperationists1963194cooper_ationists
preservationist2062804preservationist_
reservationist17114334_reservationist_
reservationists1873694_reservationists
coacervations2053875coacervation_s__
consecrations1749215consecration_s__
conservatism19104955conservat___is_m
conservatisms2083535conservat___isms
conservatives2195195conservati_ves__
conservatizes27114455conservati_zes__
conservatizing2983095conservati_zi_ng
conservatoire1862765conservat_o_i_re
conservatoires1962185conservat_o_ires
conservatorial1972245conservat_ori_al
conservatories1962545conservat_ori_es
conservators1755975conservat_o_rs__
consternations16116045consternation_s__
contortionist15104425contor__tionist_
contortionists16103365contor__tionists
conversations1847455conversation_s__
observations1785015_observation_s__
operationist1457945_o_per_ationist_
operationists1556055_o_per_ationists
annexationist20233036_anne_xationist_
annexationists21192576_anne_xationists
coacervation1964276coacervation____
colonizationist26102186colonizationist_
condemnations1845406condemnation_s__
condensations1646276condensation_s__
confirmations2055676confirmation_s__
conformations2046726conformation_s__
congelations1549736conge_lation_s__
congregations17186416congregation_s__
conjurations2148496conjur_ation_s__
conscriptions1955006conscription_s__
consecration1649786consecration____
consecutions1647056conse_cution_s__
conservative20106996conservat___i_ve
conservatively25133876conservati__vely
conservatize26125506conservat___i_ze
conservatized28113606conservat___ized
conservator1656376conservat_o____r
conservatorship2571696conservat_orship
conservatory2054756conservat_o___ry
considerations1764846consider_ation_s__
consignations16105936consignation_s__
consociations1747516consociation_s__
consolations1449746cons_olation_s__
conspirations1747726conspiration_s__
constellations1654406constellation_s__
consternation15106366consternation____
constipations1747686constipation_s__
constrictions1747786constriction_s__
constructions1747716construction_s__
constructivist21214196constructi_vist_
constructivists22223076constructi_vists
consultations1546936consultation_s__
consummations1955156consummation_s__
contestations1547736contestation_s__
contortionistic1971726contor__tionistic
conurbations1646666con_urbation_s__
conversation1747806conversation____
conversational1954166conversation__al
conversaziones2861666conversaziones__
conversazioni2761656conversazioni___
cooperations1659196cooper_ation_s__
corruptionist1763036co__rruptionist_
corruptionists1862456co__rruptionists
creationist1379236c____reationist_
creationists1476626c____reationists
denervations1657096den_ervation_s__
enervations1478576_en_ervation_s__
innervations1546926_innervation_s__
integrationist1583686_integrationist_
integrationists1682576_integrationists
interventionist1862906_interventionist_
liberationist15124736_liber_ationist_
liberationists16143696_liber_ationists
nervations1359486__n_ervation_s__
observation1665066_observation____
observational1853186_observation__al
observationally2371996_observationally
obstructionist18113996_obstructionist_
obstructionists19103386_obstructionists
operationism1655866_o_per_ationis_m
operationisms1755096_o_per_ationisms
preservations1895546preservation_s__
reservations1588586_reservation_s__
salvationist1554406___salvationist_
salvationists1653566___salvationists

Search took 6 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 Filter178691658740.313570897.8
2DLD Change Limit65874965.36012289.9
3Display Results96960.0761263.2
 (SQL Overall)178691965.74931082.1
 
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.