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

45 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
sedimentologist1992111sedimentologist_
sedimentologic2081343sedimentologi__c
sedimentologies1961553sedimentologi_es
sedimentology2061744sedimentolog___y
selenologist1357005se__len_ologist_
selenologists1455335se__len_ologists
climatologist1873946_clim_atologist_
climatologists1983276_clim_atologists
cosmetologist1853976_cosme_tologist_
cosmetologists1953146_cosme_tologists
criminologist1863646_crimin_ologist_
criminologists1952976_crimin_ologists
demonologist1657056__demon_ologist_
demonologists1755566__demon_ologists
deontologist1457416__d_eontologist_
deontologists1555926__d_eontologists
dermatologist1786466de_rm_atologist_
dermatologists18134916de_rm_atologists
diabetologist17133146__diabetologist_
diabetologists18122816__diabetologists
dialectologist1882676__dialectologist_
dialectologists1992396__dialectologists
epidemiologist2062766_epidemiologist_
epidemiologists2162496_epidemiologists
gerontologist1555986ge__rontologist_
gerontologists1654856ge__rontologists
hematologist18219206he__m_atologist_
hematologists19217046he__m_atologists
herpetologist1984796he_rpe_tologist_
herpetologists2083636he_rpe_tologists
limnologist1446686__lim_n_ologist_
limnologists1545326__lim_n_ologists
nematologist15208476ne__m_atologist_
nematologists16166596ne__m_atologists
phenomenologist2382686phenomen_ologist_
primatologist18175306_prim_atologist_
primatologists19184346_prim_atologists
seismologist15125276se_i__smologist_
seismologists16124196se_i__smologists
semiologist14410716se__m__iologist_
semiologists1548226se__m__iologists
sentimentalist16155456sentimental__ist_
sentimentalists17144626sentimental__ists
sinologist11510666s__i__n_ologist_
sinologists1257676s__i__n_ologists

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.0931921408.6
2DLD Change Limit65874455.23312588.2
3Display Results45450.0331363.6
 (SQL Overall)178691455.35933344.1
 
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.