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

73 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
pretrials115814(None) 
pretrial10511981pretrial_
retrials8510821_retrials
arterials949692arterials
predrills1244472predrills
pretorial11512652pretorial_
pretorians1258312pretorians
pretrains11410142pretrains
pretreats1146932pretreats
pretrims1238982pretri_ms
retrial7615552_retrial_
aerials74017553_ae_rials
armorials1145663armorials
arterial8313633arterial_
decrials1137133_decrials
fetials103711743_fet_ials
gremials1136133gre_mials
materials11510803materials
mistrials1148143mistrials
partials101911963part_ials
perennials1244893perennials
perils84121853p_e_ri_ls
petals84719813p_et__als
petrale9312623p_etr_ale
petrales10312983p_etr_ales
petrels9279373p_etr_els
petrols92913083p_etr_ols
peytrals1355493peytr_als
pictorials1445493pictorials
poetries10315583poetri_es
praetorial1257093praetorial_
praetorians1364623praetorians
preaxial1746973preaxial_
prebills1237293pre_bills
preboils1267293preboi_ls
prechills1645123prechills
precrisis1346453precrisis
predial103815413pre_dial_
predries112714383predri_es
predrill1145933predri_ll
preoral9312673preor_al_
preprices1569263preprices
preprints1347473preprints
pretells1047333pret_ells
preterites12411793preterites
preterits11410963preteri_ts
pretorian11511553pretoria_n
pretrain10310923pretr_ain
pretreat10311923pretrea_t
pretrim11310783pretri__m
pretties10615133pretti_es
prettily1337283pretti_ly
pretzels1934033pret_zels
prevails1337663prevai_ls
prewraps15114053prewr_aps
reburials1143933_reburials
redials84416883_re_dials
redrills956083_redrills
reprisals1144563_reprisals
retails74718973_retai_ls
retial64724993_ret_ial_
retinals85612963_retinals
retotals838463_retotals
retrains8314533_retrains
retral64419743_retr_al_
retreads937823_retreads
retreats8311413_retreats
retries74129073_retri_es
retrievals1342623_retrievals
retrims93612373_retri_ms
serials73919753_se_rials
tertials8510073tert_ials
trials64319883___trials

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.436409841.7
2DLD Change Limit148641737.53319732.0
3Display Results73730.0302433.3
 (SQL Overall)178691737.99922339.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.