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

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

50 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
prosaists115750(None) 
prosaisms1346271prosaisms
prosaist10611581prosaist_
prosaism1268042prosais_m
prosodists1345942prosodists
protists10313362pro_tists
archaists1446583archaists
arsonists947413arsonists
cosmists1237993_cosmists
ironists839293iro_nists
parodists1248513paro_dists
persists1049183pers_ists
pollists10910823p_ollists
poloists10910523p_oloists
posits85718713p_os_i_ts
praises94121103pr__aises
precasts1239453preca_sts
preexists1844733preexists
presifts1366593pres_ifts
privatists15176053privatists
probits112712573pro_bi_ts
procaines13311523procaines
proclises1339543proclises
proclisis1346773proclisis
profits122911243pro_fi_ts
prolapses13145573prolapses
prolapsus13132683prolapsus
prologists13311173prologists
promises122916763pro_mises
prosaic11311163prosai__c
prosaical1346973prosaical
prosects1239473pros_ects
prosiest10416523prosiest_
prosit85124593pros_i_t_
prosodist1248913prosodist_
prospects1545103prospects
prosses94019513pros__ses
prossies101515223prossi_es
prostatisms1555863prostatisms
prosties101421193prosti_es
protases102115033prota_ses
protasis102411973prota_sis
protests10310493pro_tests
protist9320223pro_tist_
provisos1336913pro_visos
provosts1336083pro_vosts
pyrosises1457583pyros_ises
resists74414923_res_ists
roasts64915413_ro_a_sts
royalists12178113_royalists

Search took 9 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.420425454.8
2DLD Change Limit148641507.87618872.7
3Display Results50500.0301666.7
 (SQL Overall)178691508.32621461.8
 
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.